Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Hide or show values in Dimension

Hi,

In my pivot I want to show or hide values if have a condition:

Hide BALLESTEROS because in Producto have a condition APRO

pivot_Hide.PNG

 

Labels (1)
1 Solution

Accepted Solutions
Or
Master
Master

No promises this will work for every scenario, but at least in a basic one, it should work correctly:

=if(Wildmatch(Aggr(Concat(Producto),Medicos),'*APRO*'),Null(),Medicos)

And make sure this dimension has Suppress Null Values enabled.

Replace the '*APRO*' with whatever condition it is you are checking against, assuming that condition is a specific Producto. If it's something else, you may have to get creative with adapting this approach.

View solution in original post

1 Reply
Or
Master
Master

No promises this will work for every scenario, but at least in a basic one, it should work correctly:

=if(Wildmatch(Aggr(Concat(Producto),Medicos),'*APRO*'),Null(),Medicos)

And make sure this dimension has Suppress Null Values enabled.

Replace the '*APRO*' with whatever condition it is you are checking against, assuming that condition is a specific Producto. If it's something else, you may have to get creative with adapting this approach.

View solution in original post