topic Re: Expression to subtract rows in pivot table in QlikView

Expression to subtract rows in pivot table

Anonymous — Mon, 20 Nov 2017 03:32:34 GMT

Hello,

I would like to use an expression to subtract the value of one dimension from other to get the difference please.

So I would like to subtract the first product from the below product to get the difference in values.

Thanks,

Esther

Re: Expression to subtract rows in pivot table

Anil_Babu_Samineni — Mon, 20 Nov 2017 03:35:01 GMT

Try to use

Above(Sum(Sales))

Re: Expression to subtract rows in pivot table

Anil_Babu_Samineni — Mon, 20 Nov 2017 03:40:16 GMT

My intention is this?

Sum(Sales) - Above(Sum(Sales))

Re: Expression to subtract rows in pivot table

sunny_talwar — Mon, 20 Nov 2017 11:36:49 GMT

But what is the point of doing this? What is the final goal you are trying to achieve?

Re: Expression to subtract rows in pivot table

Anonymous — Mon, 20 Nov 2017 13:22:40 GMT

I need to find out the difference between the two values

Re: Expression to subtract rows in pivot table

sunny_talwar — Mon, 20 Nov 2017 13:24:58 GMT

I guess I understand, but what is the use of finding difference between different products across the whole chart where I am guessing you might have more than just 2 products?

Re: Expression to subtract rows in pivot table

Anonymous — Tue, 21 Nov 2017 02:33:13 GMT

Hello,

I just made up that example to find out what the correct expression was. I needed it for my summary table it will not be used to find the difference between several products.

Re: Expression to subtract rows in pivot table

sunny_talwar — Tue, 21 Nov 2017 12:09:21 GMT

So you have got what you wanted then?