Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
oscarmqz
Contributor III

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
MVP
MVP

Re: showing last expression column in pivot

Use Calculated Dimension

IF(Period = 'Q214', Period)

Select Suppress When Value is NULL

Employee
Employee

Re: showing last expression column in pivot

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

Thanks.

oscarmqz
Contributor III

Re: showing last expression column in pivot

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

oscarmqz
Contributor III

Re: showing last expression column in pivot

Hi Greg, I'm applying it to the expression

Employee
Employee

Re: showing last expression column in pivot

Can you share the file please?

oscarmqz
Contributor III

Re: Re: showing last expression column in pivot

Here you go

Employee
Employee

Re: Re: Re: showing last expression column in pivot

Is this what you are after?

oscarmqz
Contributor III

Re: Re: showing last expression column in pivot

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

Employee
Employee

Re: Re: showing last expression column in pivot

Hopefully - My response was helpful.