Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Calculate difference between data in columns of pivot table.

Hi,

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

Thanks in advance for the help

Regards,

Utsav

Tags (3)
1 Solution

Accepted Solutions

Re: Calculate difference between data in columns of pivot table.

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,

3 Replies

Re: Calculate difference between data in columns of pivot table.

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


talk is cheap, supply exceeds demand

Re: Calculate difference between data in columns of pivot table.

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,

Not applicable

Re: Calculate difference between data in columns of pivot table.

Thank You for the valuable inputs.

Community Browser