Qlikview Questions and Answers

QlikView Architecture :

·         Optimized and unoptimized QVD Load Situations?

·         Explain 3 tier architecture implementation while deploying QlikView application?

·         Briefly explain how does QlikView storage the data internally?

·         What are the restrictions of Binary Load?

·         How are NULLS implemented in QlikView?

·         How do you optimize QlikView Application? (What tools are used and where do you start?)

·         What is the difference between Subset ratio & Information Density?

QlikView Scripting :

·         What is the difference between ODBC, OLE DB & JDBC?

·         What is the use of Crosstable prefix in QlikView Load Script?

·         What is Mapping Load & ApplyMap() ?

·         Synthetic Keys in QlikView and how & when to avoid them?

·         Different flavours of Joins in QlikView?

·         What is the difference between Join & Keep?

·         How do you use Having clause (SQL Equivalent) along with Groupby in QlikView?

·         Explain IntervalMatch function in QlikView?

·         Explain Concatenation, No Concatenation & Auto Concatenation?

·         Explain how to implement Incremental Load?

·         What is Circular Loop and how do you avoid it?

·         Explain Exists() function in QlikView and when do you use this function?

·         What is Generic Load in QlikView?

QlikView Expression Language / UI :

·         Explain Aggr Function?

·         What is the use of FirstSortValue in QlikView?

·         What are Set Modifiers and Set Identifiers?

·         What is P() & E() and where do you use them?

·         What is the difference between ValueList() and ValueLoop()?

·         What is Partial Reload? and why do you use “ONLY” Qualifier?

·         What is the difference between Cyclic Group & Drilldown Group?

·         Explain alternate states and where do you use them?

QlikView Security :

·         Describe Section Access architecture?

·         What is the difference between Authentication & Authorization in QlikView? And how to implement them?

·         What is the difference between File System Security vs Section Access?

·         Explain “Strict Exclusion” while implementing Section Access and what are the implications of not using this option?

·         How do you implement Section Access on hierarchy based data?

QlikView Server & Publisher :

·         What are the multiple protocols defined for client communication with QVS?

·         Explain different communication encryptions for Windows Client & AJAX Client?

·         What is the use of Anonymous User Account in QVS?

·         What are the different types of CALs and explain them?

·         What are the different editions of QlikView Server?

General :

·         Difference between Star Schema & Snow Flake Schema?

·         Difference between RDBMS & Associative Database?

·         Ragged Hierarchies in Datawarehousing

·         Explain EAV data modelling technique?

·         What are slowly changing dimensions?