suppress rows in pivot table based on 2 dimension

becki_kain — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: suppress rows in pivot table based on 2 dimension

sunny_talwar — Fri, 27 Oct 2017 17:14:02 GMT

Check attached....

Re: suppress rows in pivot table based on 2 dimension

becki_kain — Fri, 27 Oct 2017 17:16:29 GMT

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

topic suppress rows in pivot table based on 2 dimension in QlikView

suppress rows in pivot table based on 2 dimension

Re: suppress rows in pivot table based on 2 dimension

Re: suppress rows in pivot table based on 2 dimension