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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
cristian_av
Creator III
Creator III

Show/Hide Columns of Graph Based of a List

Hi

I have a pivot table and I want to hide/show some columns based on a selection of a field.

I'm using this expression to hide/show them:

=Substringcount(','&concat(distinct Dimensiones, ',')&',', ',Especie,')=1

The trouble is that when I UnSelect All, all the columns appears, and I need that they appear only if selected.

In other words, as default, columns should be hide.

borrar.png

Any idea? Thanks!!

1 Solution

Accepted Solutions
cristian_av
Creator III
Creator III
Author

Solved!

=if(GetSelectedCount(Columnas)=0,0,Substringcount(','&concat(distinct Columnas, ',')&',', ',Especie,')=1)

View solution in original post

2 Replies
cristian_av
Creator III
Creator III
Author

Solved!

=if(GetSelectedCount(Columnas)=0,0,Substringcount(','&concat(distinct Columnas, ',')&',', ',Especie,')=1)

ramasaisaksoft

Hi KJH,

I hope you are asking in Ad-hoc Reporting concept?

any way you got the solution as per your expectations so please close the thread.