topic Re: Aggr without Dimension in QlikView

Aggr without Dimension

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have scenario like below, but the challenge is in my chart there is no dimension but I need to compare with each record of NS.

if we have dimension then we can use if(sum(Sale_X) - sum(Sale_Y)>0, sum(Sale_X) - sum(Sale_Y)), but without dimension I am not getting 10+30(possitve diff value). Can some have any suggestion on this scenario. Need in front end only.

NS	Sale_X	Sale_Y	Difference Amount	Expected only sum of Possitive difference ammount
A	10	20	-10
B	40	30	10	10
C	80	50	30	30
D	100	120	-20

- Priya

Re: Aggr without Dimension

sunny_talwar — Mon, 10 Oct 2016 11:03:44 GMT

Is this in a text box object? May be try this:

Sum(Aggr(If(Sum(Sale_X) - Sum(Sale_Y)>0, Sum(Sale_X) - Sum(Sale_Y)), NS))

Re: Aggr without Dimension

sunny_talwar — Mon, 10 Oct 2016 11:05:38 GMT

Or even this might work:

Sum({<NS = {"=Sum(Sale_X) - Sum(Sale_Y) > 0"}>} NS)

Update: My bad, I meant this:

=Sum({<NS = {"=Sum(Sale_X) - Sum(Sale_Y) > 0"}>} Sale_X) - Sum({<NS = {"=Sum(Sale_X) - Sum(Sale_Y) > 0"}>} Sale_Y)

Sample attached

Re: Aggr without Dimension

priyarane — Mon, 10 Oct 2016 11:25:23 GMT

this is correct but creating performance issue