Set Analysis or else?

[alexpanjhc]

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

[Gysbert_Wassenaar]

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.

[alexpanjhc]

Can you provide solution for both if possible?

[Gysbert_Wassenaar · Accepted solution]

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.

[alexpanjhc]

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

[alexpanjhc]

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