Qlik Community

App Development

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

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
phillipmason
Contributor
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
Creator
Creator

Something like this?

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

phillipmason
Contributor
Contributor
Author

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

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.