need help with join

Wed, 20 Jul 2011 18:17:52 GMT

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

Re: need help with join

Wed, 20 Jul 2011 21:04:15 GMT

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

topic Re: need help with join in QlikView

need help with join

Re: need help with join