Difference between values expression in a pivot table

[Anonymous]

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

[vishsaggi]

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

[devarasu07]

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)

[Anonymous]

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