topic Re: Apply map in QlikView

Apply map

upaliwije — Thu, 14 Sep 2017 06:24:06 GMT

I have in my data table following two data tables

mapfleet

I have applied the following script

IF(MATCH(POL_TYPE,'N','R'),ApplyMap('mapfleet',POLICY_NO,'Null')AND IF(POL_TYPE='F',Nos))as NOS_RISKS

Although the script runs without any error result for the Nos_Risks is 0. Result should be 9

Pls see this correct my script

Anil_Babu_Samineni — Thu, 14 Sep 2017 06:27:12 GMT

And operator can works only within IF statements. You can try this?

IF(MATCH(POL_TYPE,'N','R'),ApplyMap('mapfleet',POLICY_NO,'Null'), IF(POL_TYPE='F',Nos)) as NOS_RISKS

prma7799 — Thu, 14 Sep 2017 06:31:52 GMT

Like this ??