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
