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