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: 
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
MVP
MVP

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

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.