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: 
Not applicable

Measurement properties inside a pivot table

Hi all,

I have a pivot table like:

1.PNG

And I need to show only the names that include "_D_"

I.e. I need to get the following:

d.PNG

Any ideas, plese ?

Thanks a lot in advance!

1 Reply
prieper
Master II
Master II

Either use a calculated dimension, like

= IF (WILDMATCH(Name, '*D*'), Name)

or do something similar in the expressions (and do not show NULL-values):

SUM(IF(WILDMATCH(Name, '*D*'), MyValue))

Peter