need help with join

[#1]

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...

Regards

[#2 · Accepted solution]

Hi There,

Here is the solution.

You have to do a left join between the history details & the current details to find

the conversion.

I have attached the solution based on your sample data set.

Hope this helps,

Regards,

Bikash