Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Luk_B
Contributor III
Contributor III

Compare rows in pivot table

Hi,

I have 2 rows (a single dimension) in the pivot table which are calculated independently and need a 3rd one which will check whether value in the 1st or 2nd row is higher and choose the higher as the result in the 3rd row.

Luk_B_0-1604437320909.png

 

The columns are months.

What's the best approach to calculate the final 3rd row?

If I have calculations in variables, is there anything better than

if(vCalcDim1>vCalcdim2,vCalcDim1,vCalcDim2) ? 

This is really performance inefficient.

Thanks ,
Luke 

Labels (1)
0 Replies