topic Re: Exclude Mulitple Dimensions from a Pivot Table - Qlik Sense Desktop in App Development

Exclude Mulitple Dimensions from a Pivot Table - Qlik Sense Desktop

phillipmason — Thu, 02 Nov 2017 13:12:33 GMT

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

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

ninnartx — Fri, 03 Nov 2017 02:00:31 GMT

Something like this?

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

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

phillipmason — Mon, 06 Nov 2017 12:58:19 GMT

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?

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

theglenndavid — Mon, 06 Nov 2017 22:40:55 GMT

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.