Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
becki_kain
Contributor III
Contributor III

suppress rows in pivot table based on 2 dimension

I need to suppress rows in these pivot charts where either VEH_TYPE='Unk' or Segment='Unk'. these entries are getting counted in the variable  total_sales_vol_tp1=sum({1<[TP]={$(TP1)}>} TOTAL Volume) and that's the only place i need them counted.  I can't leave the rows out, when i pull the data in from sql->alteryx->qlik because i need the unknowns counted in the total and the user is picking the time periods, in qlik.  I searched here and tried things like:

=aggr(only({<Segment-={'Unk'}>} Segment),Segment)

=If(not Match(VEH_TYPE, 'Unk'), VEH_TYPE)

but those don't work because i need the OR between the dimensions- where VEH_TYPE or Segment = 'Unk', do not show.  Help, please?  and I've included a sample of the workflow.

thanks

becki kain

1 Solution

Accepted Solutions
sunny_talwar

Check attached....

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Check attached....

Capture.PNG

becki_kain
Contributor III
Contributor III
Author

wow, perfect. I was making this WAY harder than it had to be!