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: 
poojashribanger
Creator II
Creator II

Hiding Column in Pivot table

Hi,

I want to hide columns with null value in measure.

Thanks.

2 Replies
YoussefBelloum
Champion
Champion

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

luizcdepaula
Creator III
Creator III

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