QlikView Top 50 Interview Questions with Answers.
1.What is cross table? Ans: cross table is common type of table featuring a matrix of values between two Ans: orthogonal lists of header data. To turn cross table into straight table use cross table prefix Ex. Cross table(attribute field, data field[ in])(load/select statement). 2.What is Inline memory in QlikView? Ans: create table or add field to the table. 3.what is Set and let in QlikView and difference between it? Ans: SET or a LET statement is often used To define the variable. The SET statement is used when you want a variable to hold the string or numeric value that is to the right of the Equal (=) sign.The LET statement is used when you need to evaluate what is to the right of the Equal sign e.set myVar=52 the result is “52″ Let myVar=5*2 the result is “10″ 4. Explain Join? Ans: Joins are mainly used for retrieving the data from 2 or more tables - in QLIKVIEW join will join two or more tables and convert into one...