Comapre 2 data sets

parpatra — Wed, 10 Nov 2010 21:32:33 GMT

Hi,

I have a requirement to comapre 2 data sets one at a transaction level and one at an aggregated level.

Ex. I have a loans table and a branch table. The loans table has all transaction level details and contains lots of flags on basis of which a value is calculated. (Say A). A=sum((if Flag='Y',colA)). The Branch info is present in Loans table.

The Branch table has a pre calcuated value (Say B) for each month.

Now I have to show a bar chart whose dimension is Month and expression is sum(A)/Sum(B).

I can think of applying the logic at script level and grouping the data to the branch level and calculating A and then simply comparing it with B on chart, but I have 5 different things to calculate based on different conditions and comapre it with 5 different values of branch table.

Please suggest me a good approach.

Thanks

topic Comapre 2 data sets in QlikView

Comapre 2 data sets