Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
terl
Contributor
Contributor

Show pivot table columns only in totals

Hello everybody,

at our company we are happy users of qlik sense since a view months. But there are very few things wie coudn't figure out, and I could not find any forums postings with this exact problem. Then again it seems like a thing that totally should possible somehow:

What we want to do is a pivot table with totals columns. But we want to show specific columns only in the totals.

See the screenhot...

1. is it possible to hide the "Measure2" columns in the individual months, but show it in the totals?

2. what we want is an extra column in the totals showing not the sum, but the difference of the value of the previous year (which would be on the far right of the table).

I total understand was SecondaryDimensionality() etc. does, but I couldn't get it to work. My idea was to use e.g. SecondaryDimensionality()=0 in "Show if", but that das nothing at all.

Any hints? What did we miss?

Unbenannt.png

Labels (2)
0 Replies