topic Re: nest iif statement for Pixel Perfect in Qlik NPrinting

nest iif statement for Pixel Perfect

mstoler — Thu, 15 Oct 2020 14:14:29 GMT

Hello,

I am trying to create a nested if statement like below but the syntax is not accepted.

Are nested if statements supported?

Thanks,

Michael

iif([PG]=1,'Item1',
Iif([PG]=2,'Item2',
Iif([PG]=3,'Item3',
Iif([PG]=4,'Item4',
Iif([PG]=5,'Item5',
Iif([PG]=6,'Item6',
Iif([PG]=7,'Item7'
)))))))

Re: nest iif statement for Pixel Perfect

Ruggero_Piccoli — Thu, 15 Oct 2020 14:29:33 GMT

Hi,

Yes, nested if are supported.

Maybe it is because you used lif([PG]= instead of iif([PG]=. I mean, be sure you always used iif() because l could be confused with I.

Where are you trying to add the nested if?

Best Regards,

Ruggero

Re: nest iif statement for Pixel Perfect

mstoler — Thu, 15 Oct 2020 14:26:50 GMT

Hello,

What I want to do is say if PG=1 then return 'Item1', if PG=2 then return 'Item2', etc.

The problem I have is PG is dual field and in NPrinting I only get the number. I need the Item. I can't modify the Qlik document now. Is there a better way?

Thanks,

Michael

Re: nest iif statement for Pixel Perfect

Ruggero_Piccoli — Thu, 15 Oct 2020 14:43:37 GMT

Hi,

You could also try to use ToInt(): iif(ToInt([PG])=1,'Item1',...

or ToStr(): iif(ToStr([PG])='1','Item1',...

Yes, sometimes to develop PixelPerfect formulas you have to try, test, change, try again. Forcing tha data type to text of add formulas in the source app would be better.

Best Regards,

Ruggero

Re: nest iif statement for Pixel Perfect

mstoler — Thu, 15 Oct 2020 15:43:44 GMT

Hello,

Unfortunately I cannot modifiy the source of this Qlik Dashboard.

Michael