1 Reply Latest reply: Jul 20, 2011 5:04 PM by Bikash Debnath RSS

    need help with join

      Hi All,


      I am a newbie in qlikview and have been struck in this problem, though am trying for a while but not able to get desired output.


      here's the problem statement:  I have 2 excel file, one for history data and other for current data, now i need to get the output where it has to satisfy 2 conditions; 1. Status should be converted from pending to DIN     and  2.  R_Flag should remain "yes".


      Based on above conditions the output should have:

      1. Ratio of count of converted ID  to  count of total pending ID,     so in our case

      Count of Converted Items=1.

      Count of Pending Items = 2.

      Hence ,

      1/2 = 50%


      2. Ratio of total converted value  to total pending value,     so in our case  $50/ ($100 + $200)  =  1/6  = 16%


      I have attached both the excel file for your kind perusal.


      Please help...