Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
fzalexanderjohn
Creator
Creator

Pivot Table - Only show Column for one dimension

I wonder if it is possible to show certain column only if certain dimensions are expanded.

I tried using the "show column if" feature but I could not get it to work.

I tried

Dimensionality()<>1

but I could not get it to work. This works exactly how I want for background color for example.

Labels (1)
1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III

There is no way for the model to tell if the dimensions are expanded or collapsed. It may be possible to check via deep dive into javsacript, or check if somebody has done something like this in an extension on Qlik Branch:(https://developer.qlik.com/ 

Dimensionality() will not help here as it is not dependent on the dimensions being expanded or collapsed.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein