Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Reuse Measure in Pivot Table

Hello
got a pivot table with several measures
suppose the header of these measures is Measure1, Measure2, Measure3, Measure4, Measure5
Measure5 will be Measure1 - (Measure2 + Measure3 + Measure4)
so I'm using the header of measures 1,2,3, and 4
but the expression editor is displaying an Error
kindly advise on how to fix this as this was feasible in QlikView

I can walk on water when it freezes
Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

There's no issue using measure names within a Qlik Sense pivot table that I know of, though I would advise you add these as master measures and reference those instead of creating ad-hoc object measures, at least in most cases. Note that if you are using a master measure, you need to reference the master measure's name, not its label.

Or_0-1658223016946.png

Or_1-1658223029669.png

 

View solution in original post

1 Reply
Or
MVP
MVP

There's no issue using measure names within a Qlik Sense pivot table that I know of, though I would advise you add these as master measures and reference those instead of creating ad-hoc object measures, at least in most cases. Note that if you are using a master measure, you need to reference the master measure's name, not its label.

Or_0-1658223016946.png

Or_1-1658223029669.png