“Knowledge cultivates your seeds and does not sow in your seeds.” – Khalil Gibran

In this first post – I’ll discuss various aspects of the interview questions. I’m sure some people like this approach for providing helpful hints and thought provoking questions, and others might dislike this approach because they feel it is nothing more than cheating.  So I have decided not to post the answers here and I wanted to encourage the readers to find the answers. There is plenty of material available to find these answers through QlikView Training, Reference Guide, White Papers, QlikView Community and other QlikView Blogs. So I’d encourage you to make the effort of finding the answers and learn the concept. I’ll keep adding questions…so stay tuned. Happy learning! Please note : These are just potential questions and by no means these questions will help you to get a job or succeed in your role. I’d strongly encourage you to spend time to learn QlikView instead of depending on these questions. This is just my personal repository of Questions. Good luck!

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?

90 Comments

  1. chandraani
    Jul 21, 2014 @ 17:26:18

    hii all
    can you please send any resumes on qlikview to my mail chandra.majjaru@gmail.com
    thanks
    regards

    Reply

  2. chandra
    Jul 21, 2014 @ 13:46:21

    Can you please send any experience resume to my mail chandra.majjaru@gmail.com

    Reply

  3. Anusha
    Jul 16, 2014 @ 11:11:45

    Please provide the answers for these questions .these r vry helpful to me plzzzzzz send answers to my mail : anushachowdary.k@gmail.com

    Reply

  4. venkatesh
    Jul 11, 2014 @ 18:38:23

    can any one please send me the answers to my mail id venkat.qlik@gmail.com

    Reply

  5. Charitha
    Jul 09, 2014 @ 12:30:43

    Can you please share the answers of the above questions it would be helped to me alot.

    Thank you in advance.
    -Charitha

    Reply

  6. hassan
    Jul 07, 2014 @ 16:05:48

    hi Can anyone please send me the answers to my email: smhassen@gmail.com

    Reply

  7. pratap
    Jul 03, 2014 @ 17:11:41

    please share to melp me any body those questions answers….please i need a job…he

    Reply

  8. Sam
    Jul 01, 2014 @ 16:24:03

    Hi,
    Can you please send the answer to mail
    emteam@hotmail.fr

    Best Regards,

    Sam

    Reply

  9. subbu
    Jul 01, 2014 @ 04:41:51

    please send the answers to my mail beeravalli8@gmail.com

    Reply

  10. subbu
    Jul 01, 2014 @ 04:40:07

    please send the answers above questions beeravalli8@gmail.com

    Reply

  11. sridhar
    Jun 30, 2014 @ 10:27:28

    please send me the anwsers to this mail.
    Thanks in advance.

    Reply

  12. santosh
    Jun 28, 2014 @ 15:13:26

    Please send me the answers to my Mail id kumar.bietl@gmail.com

    Reply

  13. Saurabh
    Jun 26, 2014 @ 07:39:52

    Please can you send the answers for them on my mail, would be really helpful to me.

    Reply

  14. kumar
    Jun 24, 2014 @ 11:57:49

    Hi,
    can any one send me the answers of above questions to my mail id kvpk009@gmail.com.

    Thanks in Advance,
    kumar

    Reply

  15. madhu
    Jun 19, 2014 @ 11:28:36

    pls send me the or basics and realtime scenearios interview question and answers

    Reply

  16. shravan
    Jun 14, 2014 @ 20:16:05

    Plz send the answers to nsgoud.dwh@gmail.com

    Reply

  17. Rishita
    Jun 10, 2014 @ 17:27:14

    wonderful….

    Please email me answers. Thanks!

    Reply

  18. prathyusha
    May 28, 2014 @ 08:10:14

    plz send answers for the above questions

    Reply

  19. Sunil Kumar
    May 23, 2014 @ 13:32:42

    Please anyone can send the Qlik View live examples and interview questions to my gmail-id:

    kumar.sunil20@gmail.com.

    Reply

  20. Santosh
    May 22, 2014 @ 08:13:08

    I’m going thru all your videos and its very helpful. can you please share the Q&A to my mail id: kondasantosh73@gmail.com

    Reply

  21. dasaradh
    May 19, 2014 @ 09:45:57

    please send me the answers to dasaradh.12@gmail.com

    Reply

  22. Venu
    May 18, 2014 @ 15:29:46

    Hi could you send me the answers to these questions at v4vankayala@gmail.com ??
    Thanks!!

    Reply

  23. ramu
    May 14, 2014 @ 05:52:35

    could pls send Q&A to my mail
    ramlinga2012@gmail.com

    Reply

  24. Luca
    May 09, 2014 @ 09:21:52

    Hi could you send me the answers to these questions at luppinoo@gmail.com ??
    Thanks!!

    Luca

    Reply

  25. sandeep
    May 03, 2014 @ 14:02:08

    Can u also please share the answers for above questions??

    Thanks much,
    Sandeep

    Reply

  26. Sophia
    Apr 30, 2014 @ 14:24:06

    Can you please send me the Answers for the above questions????

    Reply

  27. Varun
    Apr 27, 2014 @ 14:10:07

    Hi, could you please share the answers with me as well? 1988.varun@gmail.com :)
    Thanks in advance!!!

    Reply

    • Prerana
      Apr 28, 2014 @ 10:38:42

      Hi, could you please share the answers with me as well

      Reply

  28. veeru
    Apr 23, 2014 @ 12:57:09

    could you send me the answers to these questions..

    Reply

  29. Sophia
    Dec 10, 2013 @ 17:01:25

    Can we please get the Answers for these questions, it will be very much helpful,
    Thanks

    Reply

  30. Ravi
    Dec 05, 2013 @ 10:40:27

    Superb yar
    Could you plz send me answers to my mail-id @ raviknp438@gmail.com

    Reply

  31. kumar
    Dec 05, 2013 @ 04:59:29

    can any one please send me the answer to my e-mail kumaraswami.chunchu@gmail.com

    Reply

  32. Http://Pure.Garciniacambogiablog.Us/Privacy-Policy
    Nov 28, 2013 @ 22:38:34

    Wonderful blog you have. Do you update iit usually?

    Reply

  33. ram
    Nov 17, 2013 @ 06:14:51

    Can you send me the answers also thanks man

    Reply

  34. Prakash
    Oct 31, 2013 @ 14:33:40

    Can you please send the answer to mail
    prakash.cgb@gmail.com

    Reply

  35. imran
    Oct 25, 2013 @ 11:18:18

    Hi DV
    Can you please tell me difference between 9 , 10 ,11 qv version

    Reply

  36. asa
    Oct 14, 2013 @ 20:53:53

    Can you send me the answers also thanks man

    Reply

  37. DV
    Oct 08, 2013 @ 08:28:02

    Hi Gilman ? I?m sorry that I haven?t written the answers. They are in my head but I?ll try to write up and send you an email.

    Reply

  38. RAVI
    Oct 07, 2013 @ 06:02:55

    HI PLEASE SHARE

    Reply

  39. Gilman
    Oct 02, 2013 @ 16:34:11

    Dear Sir

    Could you send me your reference answer to me ?

    I drafted my own, I just compare my findings with you

    Reply

  40. Ash
    Sep 26, 2013 @ 01:05:50

    May you please, send me qlikview Q/A to my email : Ashrafseiff@yahoo.com

    Reply

  41. anand
    Sep 15, 2013 @ 12:11:00

    could you please send answers to my mail id?.!

    Reply

  42. shyam
    Sep 12, 2013 @ 13:48:22

    @Divya:
    Hi divya akka or Jhon,
    Can you send answers of above q?s if you got the answers on samkurma66@gmail.com.

    Reply

  43. shyam
    Sep 12, 2013 @ 13:45:29

    @Lakky:
    In 3 ways, we can avoid the synthetic keys
    1>By renaming the fields
    2>By removing field at load statement in script
    3>By concatenating the both fields by ?&? and create a new field in both tables

    Reply

    • Richard Peace
      May 07, 2014 @ 14:30:42

      Hi Shyam,

      There are more ways to remove synthetic keys, You could also concatenate the tables.
      Regards

      Reply

  44. vasu
    Sep 11, 2013 @ 08:48:49

    Thanks.
    Also please share answers to my mail
    thanq.

    Reply

  45. steven murhula
    Sep 10, 2013 @ 01:54:38

    Great qustions, DV
    Plz can u send me the answerd to my mail :engsteven@live.co.za

    Reply

  46. Suraj
    Sep 09, 2013 @ 13:42:37

    Thanks a lot for sharing. Its really helpful. could you please send the answers to my mail.

    Regards,
    Suraj

    Reply

  47. vinod
    Aug 29, 2013 @ 06:17:33

    can u send me interview q & a to my mail plz.

    Reply

  48. jon
    Aug 22, 2013 @ 00:04:43

    Thanks all the works, will you please also send answers to me?
    Thanks knowledge of temple,
    lovely,
    jon

    Reply

  49. divya
    Aug 18, 2013 @ 20:04:55

    i want answers for this questions ,please send answers to my mail

    Reply

  50. divya
    Aug 18, 2013 @ 20:04:04

    please send answers to my mail

    Reply

  51. balaji
    Jul 11, 2013 @ 11:40:31

    Anybody have sample Resumes on QlickView. Please share to balajiredy.bathula@outllok.com

    Reply

  52. pavan
    Jun 05, 2013 @ 08:42:19

    Please send the answers to my mail

    Reply

  53. Matias Caamano
    May 19, 2013 @ 03:34:10

    Hi Deepak, please help me, our company is evaluating buying qlikview between other options, so my job is to convince my boss of buying qlik is the best option by far? he is almost convinced but I need to show him a specific report that I have 90% done except for 1 task?

    I have a table, P&L report, and in the current month (real) and the real YTD column I need to show something like a hyperlink that sends the user to another table in the same qvd file with the detail of transactions for that specific account.

    for example, the user need to understand and analyse the invoices information for the exportation sells on current month or YTD column.

    please HELP!?

    Regards,

    Matias.

    Reply

  54. cardsharing fast
    May 03, 2013 @ 00:09:44

    Thanks for a marvelous posting! I truly enjoyed reading
    it, you are a great author. I will make certain to bookmark your blog and will often come
    back down the road. I want to encourage you to definitely continue
    your great writing, have a nice afternoon

    Reply

  55. premhas
    Apr 30, 2013 @ 10:38:36

    first of all thanks to admin very usefull blog,
    hey Lakky another usefull method to remove synthtic keys is LINKTABLE concept ,which is based on unique key functionality..if you want the best way to practice ,go to http://www.wowebook.com/book/qlikview-11-for-developers/ and download this book ,which is best for freshers.

    Reply

  56. DV
    Mar 29, 2013 @ 20:48:37

    Thanks Arvind. Good luck.

    Reply

  57. pavan
    Mar 29, 2013 @ 01:33:12

    Hi,If anybody have sample resume on qlikview please share with me.My Mail is pavan.pasala@gmail.com

    Reply

  58. pavan
    Mar 29, 2013 @ 01:31:35

    Hi,If anybody have sample resume please share with me

    Reply

  59. Arvind Tikku
    Mar 27, 2013 @ 09:04:50

    The questions are extremely useful.

    Can the correct answers be posted

    Reply

  60. Sagar
    Mar 05, 2013 @ 18:57:03

    How to pass a variable value from one QV document to another?

    Reply

  61. Raja
    Mar 04, 2013 @ 15:15:29

    I need answer for this question
    ?what is the main difference between Dashboard and MI solution ? ?.
    Please reply if u can answer to the above question

    Reply

  62. prashant
    Feb 22, 2013 @ 11:11:53

    pls send me all answer of above q.

    Reply

  63. DV
    Feb 18, 2013 @ 10:29:56

    Thanks Jagan. Appreciate your comments?let?s speak sometime soon.

    Reply

  64. DV
    Feb 18, 2013 @ 10:29:31

    Good question Raja. Thank you for sharing!

    Reply

  65. Raja
    Feb 18, 2013 @ 07:42:07

    Explain the difference between a document license and a client license

    Reply

  66. jagan
    Feb 13, 2013 @ 08:29:26

    Hi Deepak,

    You are doing great job. Keep it up and keep going.

    Regards,
    jagan mohan.
    http://community.qlikview.com/people/jagan

    Reply

  67. dd
    Feb 04, 2013 @ 15:57:25

    Hi,
    Can any one suggest, how to take positive values in the Input field, if user wants to enter negative values, it should take positive value instead of negative values. Is it achievable..

    Thanx in Advacnce.

    Reply

  68. DV
    Jan 16, 2013 @ 13:22:04

    Thank you very much John.

    Reply

  69. John
    Jan 09, 2013 @ 05:06:55

    just found you tonight. this is a great resource and love the videos. Thanks so much. John

    Reply

  70. sumit
    Dec 31, 2012 @ 11:26:13

    Optimized QVD load:- if are loading data from QVd without any transformation (no calculation in load script) then qlikview shows this as optimized Load.
    anf if u r using any join, conditions, transformation then this is called unoptimized load.

    Reply

  71. DV
    Nov 24, 2012 @ 22:39:23

    Prasad ? Thank you for commenting. I?d recommend you to check QlikView Community and Documentation. I?m not writing up answers here..only questions.

    Thanks,
    DV

    Deepak Vadithala

    Reply

  72. Prasad
    Nov 19, 2012 @ 11:22:45

    Any one can please post answer for Optimized and Unoptimized QVD Loads?

    Reply

  73. DV
    Nov 03, 2012 @ 10:18:38

    You are welcome!

    Reply

  74. IP Prasad
    Oct 30, 2012 @ 19:04:25

    Thanking you Sarathi

    Reply

  75. sarathi
    Sep 30, 2012 @ 18:40:51

    named CAL
    document CAL
    session CAL
    Usage CAL

    Reply

  76. DV
    Sep 05, 2012 @ 11:37:18

    Thanks Devandar. This is well documented in QlikView Server Reference Guide and there are loads of thread on QlikView Community.

    Cheers,
    DV

    Reply

  77. Devendar
    Sep 04, 2012 @ 13:13:43

    Types of CAL?s, and how do you assign them?

    Reply

  78. DV
    Sep 02, 2012 @ 09:39:41

    Sorry. I?m not providing answers at the moment. I want you guys to explore and search for the answers. I appreciate while some of the questions are conceptual but you can still find them in QlikView White Papers and other blogs. Good luck!

    Reply

  79. romi
    Sep 02, 2012 @ 08:53:14

    Pls send me d answers for all of the above questions.

    Reply

  80. Jagan Nalla
    Aug 31, 2012 @ 09:50:08

    It?s fine DV.

    Reply

  81. DV
    Aug 31, 2012 @ 09:45:46

    Jagan & Sibin ? Sorry guys. I?m not providing answers at the moment. I want you guys to explore and search for answers. I appreciate while some of the questions are conceptual but you can still find them in QlikView White Papers and other blogs. Good luck!

    Cheers,
    DV

    Reply

  82. Sibin
    Aug 31, 2012 @ 09:38:45

    I need answer for QlikView Architecture , QlikView Security, General. If possible send all answers list for my mailid

    Reply

  83. Jagan Nalla
    Aug 30, 2012 @ 11:29:29

    I need answer for QlikView Architecture , QlikView Security, General. If possible send all answers list for my mailid

    Reply

  84. DV
    Aug 28, 2012 @ 21:07:10

    Thanks Sarathi :)

    Reply

  85. sarathi
    Aug 28, 2012 @ 16:34:12

    concetanete the field
    qualify statement
    make as loosely coupled table
    using alias name
    removing the column
    join the table

    Reply

  86. lakky
    Aug 25, 2012 @ 15:09:56

    how many ways to avoid synthetic keys in qlikview??

    Reply

Leave a Reply

*