topic Re: Difference between values expression in a pivot table in QlikView

Difference between values expression in a pivot table

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

Hi all,

Is it possible to develop a formula to identify the difference between two values e.g. 10 - 5 so a column that will return 5. Please see attached for the desired output.

My current dataset in Qlikview is below.

Many thanks,

Esther

Re: Difference between values expression in a pivot table

vishsaggi — Thu, 26 Oct 2017 21:56:41 GMT

Strange your excel sheet is not downloading. May be at my end. However, can you upload your excel file again?

Re: Difference between values expression in a pivot table

devarasu07 — Fri, 27 Oct 2017 02:23:15 GMT

Hi,

You try to use dimensionality() function or try the below way

Current measure

sum({<Probability={'Current'}>}Amt)

Prior measure

sum({<Probability={'Prior'}>}Amt)

To get the difference b/w above two measure:

Column(1)-Column(2)

Re: Difference between values expression in a pivot table

Anonymous — Tue, 31 Oct 2017 21:33:38 GMT

Hello,

Thank you for your response.

That is the desired result that I would like.

I have current and prior as values under the field name week over week in the dimensions tab. Are you able to help me with this?

Kind regards,

Esther