Chennai, India – Photo Courtesy : Ram

It’s not about the answer, rather it’s about the question…

All of us ask numerous questions every day. Some of you get the definite answers and others get ambiguous answers for the same questions. If we see the reason why we get an ambiguous answer for the latter, it is evident that the question doesn’t have full details. So the most important prerequisite is that all the questions should have enough information to provide an answer. If you don’t provide all the information required for the question, no matter however simple the question is… still you will end up getting an ambiguous answer (At least, it will be ambiguous to the person who is asking the question).

For example, let me ask you simple questions and I want you to answer:

  1. “Am I wearing glasses or contact lenses?”
  2. “Am I left or right handed?”

Come on give a try, think hard, make an effort, they are simple questions to answer!!

I know these are crazy questions to ask and even if you guess the answer, the probability of getting the right answer is only 50%. I’m sure you must be thinking – “how can I give the answer without knowing the person”. Most of you would ignore to answer these questions and some of you who are willing to go extra mile to help, ask me for more details about the questions.

Then, I come back with more information on both the questions:

  1. “Sometimes I get headache when I read for long hours.”
  2. “While playing cricket I bat with left hand and bowl with right hand.”

After reading the above two statements most of you choose not to answer the questions. You must be thinking that I have I given extraneous information for the first question and contradicting information for the second question. I agree with you that I haven’t provided enough information and there is ambiguity in additional information which I have provided. And most likely I don’t get answers for the above questions or I might get an answer which is 50% correct. Although, I’m very keen to get the answer and I have decided to ask the same questions on different thread/post/community. And chances of getting the correct answers are very slim.

What was missing in my questions?

  • I haven’t provided enough information or background about myself
  • I have assumed that everyone knows about me
  • I have provided inadequate/ambiguous additional information which was not helpful

To keep it simple, I would say my questions were lacking the passion to get an answer. It shows that I don’t care to get the right answer. Asking well structured questions shows how much you care for the answer. Generally great questions lead to further unexpected detailed answers. So I encourage all of you to ask questions with complete details. Please consider the following points while asking questions on the QlikView Community.

  • Please keep the post subject line as relevant as possible. This helps other users while searching for the similar posts
  • Please give background on your data model if it’s relevant to the question
  • Post some sample data, sample QV document or screenshots wherever possible
  • Remember you can scramble the data if you have Design/UI based questions
  • Create simple Inline table and ask the question which is relevant to your problem
  • Give some background on what you  have tried and it helps us to save the time
  • Most important is marking the correct answer as “answered/helpful”. Again this helps other users who are looking for similar questions and I’m sure it encourages the person who is trying to answer your question
  • I can’t stress enough on being polite/humble while asking the question. Please remember everyone on this community is doing voluntary work
  • Please don’t post multiple times rather request someone to help you by sending a message

Now you must be thinking on how to judge if it was well structured question or not? I think any question if I answer in the first attempt, is a well structured question. I mean, any question which was asked with a great care, is more likely to get an answer in the first reply.


  1. gayatri
    Dec 06, 2016 @ 07:19:20

    i am created one dashboard for hat i am creating two same listbox and when i am select first listbox value its automatically select another listbox value because it also contain same value but i have to avoid this . how i archived this .


  2. zuwan
    Oct 08, 2015 @ 23:54:18

    can i get some videos on interval match.


  3. Chanchal
    Apr 09, 2014 @ 12:55:15


    I have a Pie chart with drill down option –>; Geo–> Code the value for this is sales$. I want to write a set analysis to stop the drill at Code, it should not show me a particular Code with 100% pie rather it should stop at Code dimension showing split in pie.
    I am trying to write a set analysis for this but its not working. Please help to write a set analysis for this.

    Thank you,


  4. Soumya Pal
    Nov 19, 2013 @ 04:47:17

    Hi, Please help me , I am facing a trouble to create a chart where I want to hide or unhide chart expression based on button click. Plz Plz help me


  5. Johann
    Oct 15, 2013 @ 11:41:26

    I sit with the following scenario that I just cannot get a solution for:
    I need to calculate a Loss Ratio (ClaimAmt/Premium).
    Dimension: CalcPeriod
    Expressions: ClaimAmt, Premium, LossRatioPerc
    The trick however is to get the correct sum of the ClaimAmt and the Premium on the same line, trying to aggregate it with a single amalgamated period Dimension that I called the ?CalcPeriod?, which in the case of the ClaimAmt is the DateOfLossPeriod and in the case of the Premium, is the FinancialPeriod. (Both the Periods have a many to many relationship and cannot be linked to each other as they are totally two separate entities.) A financial Period may have a few DateOfLossPeriods associated with it and a DateOfLossPeriod may have a few FinancialPeriods associated with it. The trick that I have to get right is to have ONLY ONE dimension set that amalgamates the two periods in one column called CalcPeriod, which will range from say M01Y2013 to M12Y2013 that will REPRESENT BOTH the FinancialPeriod for the Premium Expression Column and the DateOfLossPeriod for the Claim Expression Column on the same line.
    Any help will be highly appreciated.


  6. DV
    Oct 08, 2013 @ 08:31:26

    Hi Carlos ? I will share the QVWs going forward. Cheers.


  7. DV
    Oct 04, 2013 @ 09:42:11

    Hi Carlos ? Please email directly and I?ll share the QVW files. Going forward? I shall also provide the QVW(s). Thanks.


  8. Carlos Balenzuela
    Sep 25, 2013 @ 17:50:26


    Just a request.
    Is there a way to obtain the .QVW?s you use in your videos.
    Thank you.


  9. Bhaskar
    Jul 11, 2013 @ 09:51:04

    Hi DV,
    I could find only 2 parts (videos) for qlikview beginners which stopped in inner join. Could you please tell me where can I find the remaining videos.


  10. Praveen
    Apr 29, 2013 @ 04:05:09

    Hi All,
    I?m using Sql server 2008 R2 database to create report,one of my fact table having one measure column like IsScan this column stores either 0 or 1.
    In pie chart I need to display count of Iscan=0 and count of Iscan=1.I can able to select Isscan attribute in chart expression, I?m not able to specify any condition(Isscan=0 or Isscan=1) on that measure.
    Can you please help me on above scenario.


  11. DV
    Mar 29, 2013 @ 00:49:13

    Many thanks Alvin. I?m glad they are helpful.


  12. Priya raju
    Mar 25, 2013 @ 05:44:04

    Hi deepak,
    By following your blog videos, I written a macro but I am still facing some issue . Please help me .
    You can find my question here


  13. Alvin
    Mar 05, 2013 @ 05:16:55

    Hi Deepak?
    Just started following your blog ?. I regret to be tooo late ?.Your explanations are clear and to the point. Really appreciate for your patience and toughtprocess of being helpful to others? continue the spirit? All the best ?


  14. Gopi
    Mar 01, 2013 @ 02:17:30

    This is the first time I?m getting into the details of the website and it is just awesome. You absolutely rock..


  15. dd
    Feb 04, 2013 @ 05:52:46

    Hi, Any one suggest me, how to take only positive values in input field, if user wants to enter negative values, it should take positive values instead of negative values in input field.
    Thanks in Advacne


  16. Vishal
    Dec 20, 2012 @ 03:55:30

    I was just the watching video dat u ve posted for google maps extension. Can u tell me frm where i can download the extension dat Alexander Karlsson has used in dat example.


  17. Sonali
    Nov 09, 2012 @ 08:37:15

    I have posted my Question about Qlikview Workbench but its not yet answered.
    Here is the link,
    It would be great if you can help.


  18. kanna
    Aug 28, 2012 @ 03:40:24

    How To Crete the Dashboards And Adhoc Reports In Qlikview .kindly Send Me the Step by Step I Can do In My Own PC .


  19. DV
    Aug 28, 2012 @ 01:10:08

    Kanna ? Please check Level I videos on my blog and also look for QlikView Videos on QlikView Community.


  20. Buvana
    Jun 06, 2012 @ 11:29:56

    Thank u very much Deepak ..


  21. DV
    Jun 06, 2012 @ 10:31:16

    Thanks Buvana.
    Here are few places where you can start?
    1. Free training by QlikTech :
    2. Please register on QlikView Community, one of the best communities to get answers
    3. Install the personal edition and start reading the reference manual
    4. Install personal edition and start using with your own data
    I?ve sent you email and please let me know if you need more help.
    Deepak Vadithala


  22. Buvana
    Jun 06, 2012 @ 10:24:26

    Hi Deepak ,
    Good information and nice presentation. I am interested to learn Qlikview but very new to BI. I am not getting where to start. Can you plz help me where to start and learn . Can you plz mail me ur personal mailid to discuss. Thanks.


  23. ameri loan
    May 31, 2012 @ 20:09:41

    Keep on writing, great job!


Leave a Reply