Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Hide Pivot Table Columns when Measure is Null

Hello all,

I have a VizLib pivot table with 2 measures and 3 dimensions. The Current Fiscal YTD total should only show for the current fiscal year, but the Averages should show for all. How can I get the circled columns (DateRange) to not show up if the data is null? Include null values is currently unchecked. 

cbaqir_0-1738686271266.png

 

Labels (2)
1 Reply
Or
MVP
MVP

To the best extent of my knowledge, what you're trying to achieve is not possible.