Solved: Calculate difference between data in columns of pi... - Qlik Community

Report Inappropriate Content · ‎2012-10-31

Hi,

I want to calculate difference between two columns/dimensions generated in a pivot table.

Thanks in advance for the help

Regards,

Utsav

MayilVahanan · ‎2012-10-31

Hi

If you have two expression and for third expression, you want to calculate the difference between them means, you can use like this

=Column(1) - Column(2)

But not for dimension..

Column(1) takes the first expression used in the straight/pivot table,

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Gysbert_Wassenaar · ‎2012-10-31

diff1-3 = column(1) - column(3)

talk is cheap, supply exceeds demand

MayilVahanan · ‎2012-10-31

Hi

If you have two expression and for third expression, you want to calculate the difference between them means, you can use like this

=Column(1) - Column(2)

But not for dimension..

Column(1) takes the first expression used in the straight/pivot table,

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2012-11-01

Thank You for the valuable inputs.

Calculate difference between data in columns of pivot table.