3 Replies Latest reply: Dec 7, 2016 6:12 AM by Vineeth Pujari RSS

    Set Analysis - Why value does not show

    nayan lalla

      Hi

       

      I have a simple test data , showing number of leads  per status. For a "Won" status, only, the Conversion_1 can be "Converted" or "Not Converted" , for all other status's its "Non Converted"

       

      In my QV Model attached, I have 2 straight chart tables.

       

      Table_1 :  Show only Status that are "Won' .  The expression  I have is sum({< QV_Status = {'Won'}>}Leads)

                  

      This works perfectly!!

       

      Table_2:  Show "Converted" only.  The expression I have is sum({< Conversion_1 = {'Converted'}>}Leads)

                  

      The answer I get is zero and should be 50. Please can you help with the formula for Table_2.  Where am I going wrong?

       

      The data file and Qlikview Model are attached.

       

      Kind regards

      Nayan