topic Re: IF Condition in QlikView

IF Condition

Wed, 05 Aug 2015 18:46:25 GMT

Hello Experts,

Need your help on applying IF condition.

We have 5 groups related to Master Data and out of 5, 3 are related to Customer Master

EDM.EMEACust

EDM.CUSTOMER

EDM.LACust

EDM.MTB

EDM.PTP

First 3 groups are realted to Customer master... 4 is for Vendor and 5 is for Finance..

My result should in this model.

Customer Master

Vendor Master

Finance Master

Re: IF Condition

robert_mika — Thu, 06 Aug 2015 02:11:12 GMT

Try:

=if(match([Master Data],'EDM.EMEACust','EDM.CUSTOMER','EDM.LACust'),'Custome Master',IF([Master Data]='EDM.MTB','Vendor Master',IF([Master Data]='EDM.PTP','Finance Master','')))

or is back-end:

if(match([Master Data],'EDM.EMEACust','EDM.CUSTOMER','EDM.LACust'),'Custome Master',IF([Master Data]='EDM.MTB','Vendor Master',IF([Master Data]='EDM.PTP','Finance Master',''))) as Group

Re: IF Condition

sasiparupudi1 — Thu, 06 Aug 2015 09:05:56 GMT

use a mapping load

map22:

Mapping LOAD * Inline

[

From,To

EDM.EMEACust,Customer Master

EDM.CUSTOMER,Customer Master

EDM.LACust,Customer Master

EDM.MTB,Vendor Master

EDM.PTP,Finance Master

];

LOAD *,ApplyMap('map22',YourField,'NA')as Result Resident mytable;