hi all.. question regarding pick function in qlikview
i have one expression named Build_Burn in pivot table like
PICK($(sel),
$(var1),
$(var2),
$(var3),
$(var4),
$(var5)
)
and in this expression i have 6 variables like $(sel), $(var1),$(var2),$(var3),$(var4),$(var5)
out of these 6 expressions $(var1),$(var2),$(var3),$(var4),$(var5) are variables storing some expressions and $(sel) is a variable for selecting the remaining 5 expressions
if i give $(sel) value is 1 in variable overview.. then i can't get all 5 expressions values in pivot table right?
but i need all 5 expressions values like
Requirement
Build_Burn
Actual_ship 12
Actual_cons 23
Remain_ship 34
Remain_cons 64
Running_ship 34
if i give $(sel) is 1 in variable overview, only first expression is evaluating like below ...... but i want all expressions should be evaluated.
A variable could have only one value at the same time and therefore if $(sel) = 1 only the first expression will be returned. From your description it's not quite clear what do you want how and where to do but maybe rowno() is more suitable in your case like:
Probably you need to use for each variable a single expression - maybe without the use of variables which should be simplify things and not to make it more complicated.
