topic Re: Load if statement multiple expressions in QlikView

Load if statement multiple expressions

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

Hi there,

Just would like to know if there is a way under If statement in the Load script to have multiple expressions. For example:

If a=1, p As X, q As Y, r As Z // (a, p q, r are data fields)

instead of having 3 If statements.

Thanks

Re: Load if statement multiple expressions

DavidM — Mon, 25 Nov 2019 10:52:36 GMT

Does this mean, that if a=1 you load those three fields and otherwise not? You can do it with multiple loads with conditions (where a=1) and concatenate tables.

Re: Load if statement multiple expressions

snowman — Tue, 26 Nov 2019 01:52:41 GMT

Hi DavidM,

Yes, actually if the field a = 1, it shall load 50 fields, otherwise do nothing.

I can use 50 IF to complete this, but wonder if I can simply use one IF with 50 then expressions to make the coding look neat.

Thanks

Re: Load if statement multiple expressions

Brett_Bleess — Mon, 09 Dec 2019 18:53:49 GMT

Snowman, only other thing that came to mind might be the following Design Blog:

https://community.qlik.com/t5/Qlik-Design-Blog/Preceding-Load/ba-p/1469534

Not sure if it will help or not, figured it was worth pointing out.

Regards,
Brett