Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
poojashribanger
Contributor II

Hiding Column in Pivot table

Hi,

I want to hide columns with null value in measure.

Thanks.

2 Replies
Highlighted
YoussefBelloum
Esteemed Contributor

Re: Hiding Column in Pivot table

Hi,

on the latest releases, a new feature called: table column visibility condition is available, you can use it to hide your column expression where it is null, using this:

=len(trim(measure2))<>0

but I don't think you can do this on a pivot table..

Highlighted
luizcdepaula
Contributor II

Re: Hiding Column in Pivot table

Youssef,

This new feature is fantastic, however, when I tried to export the report with hidden columns, I got an error message "Internal engine error". Have you gone through this issue as well?

PS.: This feature only works with straight tables.

Cheers,

Luiz