topic Re: IF Statement for Pivot Table in QlikView

IF Statement for Pivot Table

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

Hey everyone,

I am trying to get the pivot table to show the data for a few groups of data, then also all of the data.

I have an IF statement that shows the 3 groups, now I want to add all of it in another IF statement. When I add all of it, it still only shows the 3 groups and not all of it.

Here is my statement.

=if(WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR'),'Internal / Warehouse to Warehouse',
if(WildMatch(SaTy_OTIF,'ZEU1','ZIN1'),'OUS',
    if(WildMatch(SaTy_OTIF,'OR','UB'),'Domestic',
    if(WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR','ZEU1','ZIN1','OR','UB'),'test'
    ))))

Re: IF Statement for Pivot Table

Siva_Sankar — Wed, 04 Oct 2017 08:20:10 GMT

may be you dont have data that falls under all the groups. it may be easy if you share us the data or the example application that you have.

-Siva

Re: IF Statement for Pivot Table

HirisH_V7 — Wed, 04 Oct 2017 09:02:30 GMT

There in the Calculated dim, your'e is using the same inclusions in other group too.so it not been displaying.

Try and create a inline load mapping for that particular field SaTy_OTIF,GroupingField.so that you can map the inline table with the Table in which your field is there.

HTH,

Hirish

PFA Example FYR.