Exclude Mulitple Dimensions from a Pivot Table - Qlik Sense Desktop

[phillipmason]

Hello

I'm trying to work out if there is a way I can exclude multiple dimensions from a pivot table (so they don't show as a row)

Example Pivot

Installer	Measures
A	10
B	20
C	40
D	56
E	15
F	12
G	13

I want to do something along the lines of

=Installer <> ('C','D','G') so that I am only showing the data for the remaining Installers.

There will be other Tables using these removed Installers, so I can't just filter them out.

Do you know if this is possible, if so how?

thank you

[ninnartx]

Something like this?

=sum({<Installer-={'C', 'D', 'G'}>}Measures)

[phillipmason]

Hi. Thanks for this, however I'm not sure its quite what I'm after.

I want to remove the installers from the list completely, what you have suggested seems to leave them in but just give me a 0 value in measures.

I want to show my data like this

Installer	Measures
A	10
B	20
E	15
F	12

So I need to apply the expression you have suggested in here, is this possible?

[theglenndavid]

Ninnart's solution should have worked as it excludes C,D,G from the calculations.

An alternative is to use: =If(Match(Installer,'C','D','G')>0,Null(),Installer) as the dimension expression. Make sure to untick the Include null values option.