topic Re: Measurement properties inside a pivot table in QlikView

Measurement properties inside a pivot table

Thu, 04 May 2017 15:06:51 GMT

Hi all,

I have a pivot table like:

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

I.e. I need to get the following:

Any ideas, plese ?

Thanks a lot in advance!

prieper — Thu, 04 May 2017 15:23:24 GMT

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