topic Set Analysis or else? in QlikView

Set Analysis or else?

alexpanjhc — Wed, 21 Nov 2012 14:51:49 GMT

Hi
I am trying to compare the following information

where on the same day, if Type A's Amount is greater than TypeB's Amount

Do i do it in set analysis or do i change the load structure?

Please help thanks!

Types	Amount	Date
A	20	10/2/2012
B	25	10/2/2012
A	50	10/3/2012
B	40	10/3/2012
A	30	10/4/2012
B	60	10/4/2012

Re: Set Analysis or else?

Gysbert_Wassenaar — Wed, 21 Nov 2012 14:59:22 GMT

That depends on what you need to do. If you need that comparison very often (in lots of charts) it would make sense to create the difference between A and B per date in the load script. Otherwise set expression will do fine.

Re: Set Analysis or else?

alexpanjhc — Wed, 21 Nov 2012 15:00:54 GMT

Can you provide solution for both if possible?

Re: Set Analysis or else?

Gysbert_Wassenaar — Wed, 21 Nov 2012 15:09:52 GMT

A table with Date as dimension and an expression like sum({<Types='{A}'>}Amount)-sum({<Types='{B}'>}Amount) would give you a table with the difference between A and B per date.

For a load script example see attached qvw.

Re: Set Analysis or else?

alexpanjhc — Wed, 21 Nov 2012 15:21:06 GMT

the set analysis is good, but I'd like to know how many days the amount of Type A is greater than Type B.

Re: Set Analysis or else?

alexpanjhc — Wed, 21 Nov 2012 15:26:18 GMT

never mind, I misread what you said... sorry and thanks!