Welcome to Qlik Question of the Day (QQotD). I’ll post Qlik questions on regular basis for you to answer and I’ll publish the results on regular basis. Also, please feel free to suggest new questions. Hopefully, Qlik Quiz will help you to learn new things. Good luck!

Follow me on twitter to get updates on latest QQotD.




Archive QQotD (Qlik Question of the Day – AKA Quiz)


QQotD 252: Question on Qlik Sense Synchronization

QQotD 250: Question on Qlik Sense

QQotD 250: Question on Qlik Sense Extensions API

QQotD 249: Question on Qlik Sense Engine API

QQotD 248: Question on Qlik Sense Roles

QQotD 247: Question on Qlik Sense Permissions

QQotD 246: Question on Qlik Sense Admin Roles

QQotD 245: Question on Qlik Sense Extensions

QQotD 244: Question on Qlik Sense Visualization Selection

QQotD 243: Question on Qlik Sense Script

QQotD 242: Question on Qlik Sense DataMarket

QQotD 241: Question on Qlik Sense Limitations

QQotD 240: Question on QlikView Power Tools

QQotD 239: Question on QlikView QVPR

QQotD 238: Question on QlikView Set Analysis

QQotD 237: Question on QlikView Services

QQotD 236: Question on AccessPoint not Loading

QQotD 235: Question on JavaScript and Java

QQotD 234: Question on QVPR

QQotD 233: Question on QlikView Logs

QQotD 232: Question on .Qext Format

QQotD 231: Question on QVB

QQotD 230: Question on QlikSense Design

QQotD 229: Question on QlikView Section Access

QQotD 228: Question on QlikView Clustering

QQotD 227: Question on QlikView IE-Plugin Support

QQotD 226: Question on QlikView $Field

QQotD 225: Question on QlikView $Field

QQotD 224: Question on QlikView Concatenate Table Operator

QQotD 223: Question on QlikView Input Fields

QQotD 222: Question on QlikView Bookmarks

QQotD 221: Question on QlikView Server QVPR

QQotD 220: Question on  QlikView Server Preload Setting

QQotD 219: Question on  QlikView Logs

QQotD 218: Question on  QlikView Logs

QQotD 217: Question on  QlikSense Server

QQotD 216: Question on QlikView Alternate State

QQotD 215: Question on QlikView Orphaned Alternate State

QQotD 214: Question on QlikView Alternate States

QQotD 213: Question on QlikView Search Functionality

QQotD 212: Question on Clear and ClearAll Event

QQotD 211: Question on Desktop Status Bar

QQotD 210: Question on  .Shared File

QQotD 209: Question on Server Audit Logging

QQotD 208: Question on Distinct Qualifier

QQotD 207: Question on Alternate States and Bookmark

QQotD 206: Question on Qualify and UnQualify

QQotD 205: Question on FirstSortedValue

QQotD 204: Question on QlikView Expression

QQotD 203: Question on QlikView Desktop Edition

QQotD 202: Question on QlikView Small Business Server

QQotD 201: Question on CALs

QQotD 200: Question on Expression Type

QQotD 199: Question on Mapping Table

QQotD 198: Question on QlikView Publisher

QQotD 197: Question on QlikView License Types

QQotD 196: Question on QlikView Scripting Command

QQotD 195: Question on QlikView QVD Load

QQotD 194: Question on QlikView Server License

QQotD 193: Question on QlikView Type Conversion

QQotD 192: Question on QlikView Hidden Script

QQotD 191: Question on QlikView Architecture Design Pattern

QQotD 190: Question on QlikView Back and Forward Buttons

QQotD 189: Question on QlikView Straight Table Chart Properties

QQotD 188: Question on QlikView Client Communication Protocol

QQotD 187: Question on QlikView Server

QQotD 186: Question on NUMA on QVS

QQotD 185: Question on Print Spooler Service

QQotD 184: Question on QlikView Index() Function

QQotD 183: Question on QlikView Session Logs

QQotD 182: Question on QlikView Floor() Function

QQotD 181: Question on QlikView ValueLoop() Function

QQotD 180: Question on QlikView Function

QQotD 179: Question on QlikView ValueLoop() Function

QQotD 178: Question on QlikView Publisher/Reload Engine

QQotD 177: Question on QlikView Server

QQotD 176: Question on QlikView Server Objects

QQotD 175: Question on QlikView Services

QQotD 174: Question on QVPR

QQotD 173: Question on QlikView Bookmarks

QQotD 172: Question on QlikView Bookmarks

QQotD 171: Question on QlikView DMS

QQotD 170: Question on Encryption/Security

QQotD 169: Question on Named CAL(s)

QQotD 168: Question on Drill-down Group

QQotD 167: Question on License Lease

QQotD 166: Question on Qlik Sense Installation

QQotD 165: Question on QlikView Services

QQotD 164: Question on QlikView Server Installation

QQotD 163: Question on QlikView Functions

QQotD 162: Question on QlikView Set Analysis

QQotD 161: Question on QlikView Functions

QQotD 160: Question on QlikView Subfield Expression

QQotD 159: Question on QlikView FirstWorkDate Expression

QQotD 158: Question on QlikView Applymap()

QQotD 157: Question on QlikView License Leasing

QQotD 156: Question on QlikView CALs

QQotD 155: Question on QlikView Mapping Load

QQotD 154: Question on QlikView Pseudo URL

QQotD 153: Question on QlikView Bookmarks & Variables

QQotD 152: Question on QlikView Binary Load

QQotD 151: Question on QlikView Formatting

QQotD 150: Question on QlikView Alternate States and Bookmarks

QQotD 149: Question on QlikView And-Mode

QQotD 148: Question on QlikView First Prefix

QQotD 147: Question on QlikView NumSum Function

QQotD 146: Question on Beacons/ Color Indicators

QQotD 145: Question on Scrambling QlikView Data

QQotD 144: Question on QlikView Binary Load

QQotD 143: Question on QlikView Rename Fields Statement

QQotD 142: Question on QlikView NullASValue Statement

QQotD 141: Question on QlikView CrossTable Table Operator

QQotD 140: Question on QlikView Partial Reload

QQotD 139: Question on QlikView Script Statements

QQotD 138: Question on QlikView CALs

QQotD 137: Question on QlikView CALs

QQotD 136: Question on Qlik Joins

QQotD 135: Question on Qlik Expression (Today Function)

QQotD 134: Question on Qlik Direct Discovery

QQotD 133: Question on Qlik QAR

QQotD 132: Question on Qlik Annotations

QQotD 131: Question on QMS Service

QQotD 130: Question on Qlik Server Services

QQotD 129: Question on Qlik Compression Mode

QQotD 128: Question on Qlik Expression (RangeSum Function)

QQotD 127: Question on Qlik Variables & Expressions

QQotD 126: Question on Qlik UI Cascading Order

QQotD 125: Question on Qlik Cloned Objects

QQotD 124: Question on Qlik Joins and Associative Logic

QQotD 123: Question on Qlik Expression (Subfield Function)

QQotD 122: Question on Qlik Server Security

QQotD 121: Question on Qlik Security (Export to Excel Functionality)

QQotD 120: Question on Qlik Expressions (Fact Function)

QQotD 119: Question on Qlik Expressions (MOD Function)

QQotD 118: Question on Qlik Expressions

QQotD 117: Question on Qlik ODBC Connections (DSN)

QQotD 116: Question on Qlik Logical Operators

QQotD 115: Question on Qlik Variables

QQotD 114: Question on Qlik Scripting Errormode

QQotD 113: Question on Qlik Server Encryption

QQotD 112: Question on Qlik Server Security

QQotD 111: Question on Qlik Control Statement

QQotD 110: Question on QlikView Extension Objects

QQotD 109: Question on QVD Files

QQotD 108: Question on QlikView Debugger

QQotD 107: Question on QlikView Set Analysis

QQotD 106: Question on QlikView Server Authentication

QQotD 105: Question on QlikView Command Line Switches

QQotD 104: Question on QlikView Prj Folder

QQotD 103: Question on QlikView Extension Objects

QQotD 102: Question on QlikView Colours

QQotD 101: Question on QlikView Grouping Option

QQotD 100: Question on QlikView Charts

QQotD 99: Question on NULLS in QlikView

QQotD 98: Question on QlikView Set Operators

QQotD 97: Question on QlikView Table Viewer

QQotD 96: Question on QlikView Set Analysis

QQotD 95: Question on QlikView Function

QQotD 94: Question on QlikView BitWise Operators

QQotD 93: Question on QlikView Rename Fields

QQotD 92: Question on QlikView Scripting

QQotD 91: Question on QlikView ODBC Connection

QQotD 90: Question on QlikView Transformation

QQotD 89: Question on QlikView Scripting

QQotD 88: Question on QlikView Memory Management

QQotD 87: Question on QlikView Command Line Syntax

QQotD 86: Question on QlikView Memory Allocation

QQotD 85: Question on Drivers/Connectors

QQotD 84: Question on Hide/Show Property

QQotD 83: Question on QlikView Input Field

QQotD 82: Question on QlikView QMC

QQotD 81: Question on QlikView Clustering

QQotD 80: Question on Crosstable prefix

QQotD 79: Question on QlikView License Lease

QQotD 78: Question on QlikView Function

QQotD 77: Question on QlikView Mid() Function

QQotD 76: Question on QlikView Sleep Function

QQotD 75: Question on QlikView loading random records

QQotD 74: Question on QlikView “Force” Statement

QQotD 73: Question on QlikView Function

QQotD 72: Question on QlikView Security

QQotD 71: Question on QlikView Chart Type

QQotD 70: Question on QlikView Data Modelling

QQotD 69: Question on Internet Explorer URL Spoofing

QQotD 68: Question on FirstSortedValue() Function

QQotD 67: Question on QlikView  Psuedo URL Connection

QQotD 66: Question on QlikView Memory Management

QQotD 65: Question on QlikView Expression

QQotD 64: Question on Subset Ratio (Meta Data)

QQotD 63: Question on QlikView Meta Data

QQotD 62: Question on QlikView Server CALs

QQotD 61: Question on QlikView Partial Reload

QQotD 60: Question on QlikView Server Protocol

QQotD 59: Question on QlikView Color Coding

QQotD 58: Question on QlikView Extension Objects

QQotD 57: Question on QlikView Parallel Load

QQotD 56: Question on QlikView License Leasing

QQotD 55: Question on QlikView Comments

QQotD 54: Question on QlikView Field Event Trigger

QQotD 53: Question on QlikView First & TOP Clause

QQotD 52: Question on QlikView Load Types

QQotD 51: Question on QVS Document Timeout

QQotD 50: Question on QlikView Joins

QQotD 49: Question on Having Clause

QQotD 48: Question on Transpose Table

QQotD 47: Question on QlikView Annotations

QQotD 46: Question on QlikView Joins

QQotD 45: Question on Information Density

QQotD 44: Question on QlikView Variables

QQotD 43: Question on QlikView Acronyms

QQotD 42: Question on QlikView Tables

QQotD 41: Question on QlikView NULL values

QQotD 40: Question on QlikView Function

QQotD 39: Question on IsNum() QlikView Function

QQotD 38: Question on  QlikView Variables

QQotD 37: Question on ValueLoop() Function

QQotD 36: Question on Hidden Script Password

QQotD 35: Question on Current Selection Box

QQotD 34: Question on QlikView ODBC Connection String Security

QQotD 33: Question on Section Access

QQotD 32: Question on QlikView Security

QQotD 31: Question on QlikView Server & Publisher

QQotD 30: Question on Only Keyword

QQotD 29: Question on Nulls

QQotD 28: Question on QlikView Function

QQotD 27: Question on “*” Wild Card

QQotD 26: Question on Scripting

QQotD 25: Question on Num() function and Number Formatting

QQotD 24: Question on QlikView Function

QQotD 23: Question on QlikView Architecture

QQotD 22: What is sort by applicability?

QQotD 21: Question on SET Variables

QQotD 20: Question on QlikView Authentication

QQotD 19: When do you see Perfect Key in QlikView

QQotD 18: How to secure QVD files…

 QQotD 17: Question on format painter:

QQotD 16: Client Communication to QlikView Server:

 QQotD 15: Question on implicit Distinct Qualifier:

QQotD 14: Lincense Lease is available on the following server editions:

QQotD 13: Question on CALs:

QQotD 12: Question on NULLS:

QQotD 11: What happens when I reload (Ctrl + R) the below script:

QQotD 10: Which of the following is not a color function in QlikView… (N.B. Please don’t check before answering)

QQotD 09: QlikView’s caching algorithm takes into account the cost of generating the calculated results…

QQotD 08: Calculation behaviour of minimized chart objects in QlikView…

QQotD 07: Using Distinct qualifier in Count() forces QlikView to switch from using multi core to use only one core…

QQotD 06: Which logic is implemented to handle NULLS in QlikView?

QQotD 05: What does the value 100 represent in Green(100) function?

QQotD 04: Is it possible to create a QVD file in UI without using script?

QQotD 03: What does ampersand (&) symbol in a List Box donate?

QQotD 02: What type of security is implemented while communicating between QlikView Server and Windows Client?

QQotD 01: Which of the following statements are not true about ApplyMap() function?



  1. Ali shan
    Jul 26, 2016 @ 20:24:51

    good blog et me know how to working with real time project.


  2. Peyman Azimabadi
    Apr 14, 2016 @ 00:30:28

    Hi DV,

    QQotD 19 is false, a key with 100% unique values is a “Primary Key”.
    A perfect key, is a “Primary Key” with 100% “Subset Ratio”.

    Best regards


  3. John Smith
    Feb 04, 2016 @ 08:27:56

    Hi DV,

    Great website, with regards to QQotd 7, so are you saying that if I use Distinct in any of my expressions that the performance will be slower due to only using single core? If that’s the case is there an alternative way?


    • DV
      Mar 26, 2016 @ 21:02:21

      Thank you. Sorry for the delayed response. This was the case in older versions of engine but not anymore. So, there’s nothing to worry when using DISTINCT clause.


  4. Mikael
    Jan 25, 2016 @ 11:14:30

    QQotd 231
    Q: “Which of the following statements are NOT TRUE about QVB?”

    A: “All of the above are true”

    This mean that the statement “All of the above are true” is NOT TRUE = all are incorrect.
    So all of the above solutions are NOT TRUE, means that every single of them is correct to answer as not true.

    So choosing the last one means all are wrong, is that correct?

    This mean that all answers are correct as not true. Though the last answer is “more” correct. Though basically you cannot answer wrong.

    Is that the point you wanted?


  5. Amit
    Dec 31, 2015 @ 12:17:03

    I am struggling with question based on server and licenses. do you have any post on that?


  6. Renjith
    Nov 01, 2015 @ 13:55:22

    very nice questions and I wonder, if answering the questions will help me for qlik certification. ?


    • DV
      Nov 04, 2015 @ 07:19:29

      Thanks Renjith. These questions are harder than certification questions. Hopefully, these will help.


  7. karo
    Jul 06, 2015 @ 09:09:53

    hi, QQotd 208 point to 207

    (thanks for quiz)


  8. Iuri
    Jun 10, 2015 @ 00:41:45


    Questions 99 and 100 are the same.


    • DV
      Jun 14, 2015 @ 09:45:42

      Thank you spotting that. I’ve updated and it’s showing right question now!


  9. Iuri
    May 15, 2015 @ 21:37:03


    Be careful with the question 144, it can lead to misunderstanding.


  10. Iuri
    Apr 29, 2015 @ 14:22:11

    Hi DV,

    The question 143: Question on QlikView Rename Fields Statement:

    QlikView Does not even ignore the second field and renames the first, when we do the reload it just gives an error. Or Am I missing something??

    Thanks in advance, I have been learning a lot with your quiz.



  11. mm
    Apr 14, 2015 @ 16:46:52

    these questions are stupid. You’ll never see these kind of strange things in an exam. They are just based on stupid wiht no importance aspects and curiosities. That’s useful if you are bored at home, but nothing more than that.


  12. Swapnil
    Apr 07, 2015 @ 12:58:52

    Excellent questions.. i must say these questions are tougher than QV_Developer_01 certification questions.



  13. SR
    Nov 03, 2014 @ 06:35:44

    Hi DV,

    Answer for 123 is NULL.
    Please refer Desktop ‘QlikView Help’ where answer will be found with explanation.



    • DV
      Nov 03, 2014 @ 10:05:04

      Thanks SR. It’s not right. Please try it yourself on desktop client.


      • SR
        Nov 04, 2014 @ 03:58:50

        Thanks DV! for responding, you may be right 🙂
        Let me check.


    • Krish
      Feb 18, 2015 @ 09:21:29

      Hi DV,

      Please refer 144 question once at Answer part.It’s showing Above as Fourth option is right one.But, the green Indicator shows the third option is right one.Which one is the right answer.Please, let me know.




  14. SR
    Oct 30, 2014 @ 22:12:02

    Hi DV,

    First of all many thanks for making available such valuable stuff to QlikView users. I am preparing for Developer exam. Not sure how depth certification questions will be. Just wanted to know from you, how much percentage that these questions will help to pass exam besides manual & material. I have already passed Server\Pub exam. I have very less experience as a Developer. Can you able to give exam passing tips.

    Best Rgds,


    • Manuel
      Apr 09, 2015 @ 15:18:12

      Hello SR,
      do you have any suggestions for the exam?
      Please, write me manusilv-83@libero.it
      many thanks


      • DV
        Apr 10, 2015 @ 09:41:51

        I’m writing a blog post of QV certification. I’ll get back to you soon!


        • Amit
          Dec 31, 2015 @ 12:07:55

          Your comment is awaiting moderation.


          Can you share link for your blog on certification.



  15. Bhawna
    Oct 13, 2014 @ 12:16:11

    Hi DV,
    I am new to qlikview,your website is very useful for the beginners to understand the QV function,your quiz help me a lot to understand the logic behind the QV function… Thank you so much.. you are doing great job.. dont stop keep posting..


    • Amit
      Dec 31, 2015 @ 12:07:20


      Can you share link for your blog on certification.



  16. Jhansi
    Sep 16, 2014 @ 17:13:09

    q160:field Mystring has a single value = Row1 | Row2| Row3 | Row4 | Row5
    then Subfield(Mystring,’|’) result is just Row1 in UI Level. But the answer marked as Row1 to Row5. May be it is correct if you use this in script level…


    • DV
      Sep 18, 2014 @ 08:37:10

      Jhansi – You’re right! I was referring to the LOAD script instead of UI.


  17. Satish
    Aug 26, 2014 @ 04:49:57

    Hi Dv,

    I’ve participated just now and how can i get the correct answers for the previous questions? because now i’cant assume that which one is correct and which one is wrong.

    So i request to help me out in this.

    Thanks in advance



  18. Suri
    Aug 07, 2014 @ 12:23:28

    can you give me some examples about question 093. I can`t understand the correct answer.
    Thank you!


  19. Alex
    Jun 09, 2014 @ 19:52:47

    Are these questions simply similar in format to the certification exam or do these questions cover material covered in the exam? IOW, does the exam test your understanding of Qlikview by making sure you understand concepts and how things work or does it test it by seeing if you know niche/random details about Qlikview quirks? A lot of the questions posed here do not seem to test understanding of how Qlikview works, but rather if you happen to remember a quirk about how Qlikview operates.


    • DV
      Jun 10, 2014 @ 09:25:10

      Thanks Alex. Not all the questions are certification exam model questions. Having taken certification – I think certification questions are easier than my questions. QQotD is not aimed at new developers instead these questions requires at least an year experience to answer. Good luck!


      • Alex
        Jun 10, 2014 @ 21:07:17


        Thank you! I feel much much better! I am taking the exam on Friday! I know I will struggle with Server and Publisher questions, but fortunately that is not a big part of the exam. Thanks! Also, question 128…why does the follwowing expression evaluate to two instead of three? Is a number still numeric even if it is surrounded by single quotes? =RangeMissingCount(2, ‘2’, ‘x’, Null() )



      • Manohar
        Aug 01, 2014 @ 17:49:22

        Question# 160 answer is wrong. it should be “first value ie ROW 1”


        • DV
          Aug 02, 2014 @ 13:44:01

          Manohar – Not sure how you’re getting first value instead of all rows. Please load a simple inline table and try using the same table as resident load with subfield function. It will always returns all the values when you don’t specify the third parameter.



  20. David Foster
    Dec 16, 2013 @ 20:17:45

    Typo in QOTD 03. It should say ?denote? not ?donate? 🙂


  21. DV
    Sep 08, 2013 @ 19:17:29

    @Alexis ? Many thanks for updating me. I?ve fixed the issue. Cheers!


  22. Alexis Hadjisoteriou
    Sep 03, 2013 @ 09:59:39

    I think there is a fault in the question/answer handling software.
    For example in Q77 I answered with ?View? and it gave me ?Ooops? even though it proceeds to confirm that ?View? was the correct answer!


  23. sandeep
    Jul 27, 2013 @ 07:15:50

    how to learn set analysis


  24. sandeep
    Jul 27, 2013 @ 07:14:59

    please tell me how to learn set analysis


  25. DV
    Nov 13, 2012 @ 18:21:46

    @Velgar ? Always helpful. Thank you very much for picking this one?

    Cheers ?DV


  26. @veglar
    Nov 12, 2012 @ 09:05:08

    Qlikview Question of the Day 18 and 19 got the same URL under the archive QQotD header.
    Both are pointing to the QQotD 18.



  27. DV
    Nov 03, 2012 @ 10:19:22

    Hi Naveen,

    Sorry for the delayed response. Please email me directly with your QVW file and I can look into it.



  28. DV
    Nov 03, 2012 @ 10:18:24

    Hi Surik ? Sorry, I?m not sure about connecting the PLM Software to QlikView but I recommend you to check the QlikView Extension Objects or QV Source.



  29. surik
    Nov 02, 2012 @ 06:37:41

    I Want to Connect Plm Software to Qlikview How Can I ,I anm Wating For Uer Reply


  30. Naveen
    Oct 30, 2012 @ 02:49:47

    Hi DV,
    I need your help with an issue in Qlikview.
    i have a dimension with duplicates.
    say for example, in Customer dimension, one customer can belong to many REP?s in same State.
    how can I join this dimension with my Transactions fact table?
    Customer1,State1,REP2 like?..


  31. DV
    Sep 14, 2012 @ 17:51:49

    Thanks Gabriel


  32. DV
    Sep 14, 2012 @ 17:51:29

    Suri- Are you asking the question or recommending the question?


  33. suri
    Sep 11, 2012 @ 13:44:40

    what is the use of normal load and add load


  34. Gabriel
    Sep 10, 2012 @ 12:57:20

    Hi Deepak,

    Many thanks for this method of learning QlikView.


  35. DV
    Sep 05, 2012 @ 11:37:46

    Thanks Narasimha. Good luck and happy learning!


  36. Narasimha
    Sep 04, 2012 @ 12:59:09

    Hi DV:

    Would like to thank you for your efforts and attention to detail. Video and QQotD are very informative.

    Keep rocking?


  37. DV
    Aug 15, 2012 @ 06:04:25

    Thanks Srere 🙂


  38. srere
    Aug 14, 2012 @ 18:34:04

    Nice Questions


  39. DV
    Aug 03, 2012 @ 06:48:00

    Thanks Aadil!


  40. Aadil
    Aug 03, 2012 @ 06:46:35

    This is nice..


  41. DV
    Aug 01, 2012 @ 05:30:59

    Thank you Raj. I?m glad you have learnt something new.

    Cheers ? DV


    • Alexandra
      Jul 01, 2016 @ 18:37:12

      I hope I'm right when I say the thing you are patnsoiase about is what I'm getting more and more passionate about everyday. Not to get anymore cryptic, I hate missing Day Zero man.


  42. raj
    Jul 31, 2012 @ 00:09:38

    good question and got something to learn


  43. DV
    Jun 14, 2012 @ 19:28:50

    Thanks Gab. Yes, I agree with you.

    Happy learning.



  44. Gabriel
    Jun 14, 2012 @ 19:26:45

    Hi DV,

    This is a very good idea and a fun way to learn.
    Keep up the good work.



  45. DV
    Jun 13, 2012 @ 09:35:48

    Thank you Jagan.


  46. JaganNalla
    Jun 13, 2012 @ 09:25:59

    Good question.


Leave a Reply