Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

showing last expression column in pivot

Hi, is there a way to hide all but one (last) column in a pivot table? Here's the screenshot, I just want to show the "QoQ" for Q214, and the simple conditional  Period='Q214' in the expression is not working, that way all the columns are hidden

Capture.PNG.png

10 Replies
MK_QSL
MVP
MVP

Use Calculated Dimension

IF(Period = 'Q214', Period)

Select Suppress When Value is NULL

Greg_Williams
Employee
Employee

Where are you applying the logic? In the Expression, for a Dimension, in the Layout tab?

Thanks.

Anonymous
Not applicable
Author

Hi Manish, that way I'd hidding everything, I do want to show the "headcount" columns for all the available periods

Anonymous
Not applicable
Author

Hi Greg, I'm applying it to the expression

Greg_Williams
Employee
Employee

Can you share the file please?

Anonymous
Not applicable
Author

Here you go

Greg_Williams
Employee
Employee

Is this what you are after?

Anonymous
Not applicable
Author

Nope, this is it.... where QoQ is the delta between last Q (Q214) minus previous (Q114)Capture.PNG.png

Greg_Williams
Employee
Employee

Hopefully - My response was helpful.