Discussion board where members can get started with QlikView.
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.
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.
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.
Snowman, only other thing that came to mind might be the following Design Blog:
Not sure if it will help or not, figured it was worth pointing out.