Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Pivot Table: Calculated Rows

Hi everyone,


i have some trouble with pivot tables.
I have already a pivot table where I show some values.
Now I want to have a second table where I show the relative difference to the selected reference (image below).

I already have a solution but I'm not happy with that. 

table_trouble.jpgthats my try but it doesnt work.





my working solution is based on sorting and "Top()" function. I sort the reference on top of the pivot table and have


 as measure. But I want the reference sorted logically. 


thats working, but not how I want it to be.


Somebody has an idea how it could work in Qlik Sense?

Thanks in advance.




Labels (3)
0 Replies