Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

phillipmason
New Contributor

Exclude Mulitple Dimensions from a Pivot Table - Qlik Sense Desktop

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
A10
B20
C40
D56
E15
F12
G13

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

3 Replies
ninnartx
Contributor

Re: Exclude Mulitple Dimensions from a Pivot Table - Qlik Sense Desktop

Something like this?

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

phillipmason
New Contributor

Re: Exclude Mulitple Dimensions from a Pivot Table - Qlik Sense Desktop

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
A10
B20
E15
F12

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

theglenndavid
New Contributor III

Re: Exclude Mulitple Dimensions from a Pivot Table - Qlik Sense Desktop

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.