topic Re: hi all.. question regarding pick function in qlikview in QlikView

hi all.. question regarding pick function in qlikview

Wed, 25 Nov 2020 16:16:04 GMT

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.

Build_Burn

Actual_ship 12

Actual_cons 12

Remain_ship 12

Remain_cons 12

Running_ship 12

Re: hi all.. question regarding pick function in qlikview

Mon, 12 Dec 2016 06:02:19 GMT

plsss solve my problem...

Re: hi all.. question regarding pick function in qlikview

marcus_sommer — Mon, 12 Dec 2016 08:20:07 GMT

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:

PICK(rowno(),

$(var1),

$(var2),

$(var3),

$(var4),

$(var5)

)

- Marcus

Re: hi all.. question regarding pick function in qlikview

Mon, 12 Dec 2016 08:36:59 GMT

hi Marcus.. thnq so much for your reply...

i want to show that expression in pivot table...but i need to show all expressions... is there any solution for that?

could u plz help me

Re: hi all.. question regarding pick function in qlikview

marcus_sommer — Mon, 12 Dec 2016 08:52:11 GMT

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.

- Marcus

Re: hi all.. question regarding pick function in qlikview

MarcoWedel — Mon, 12 Dec 2016 22:59:03 GMT

please provide a sample application to demonstrate solutions with.

thanks

regards

Marco

Re: hi all.. question regarding pick function in qlikview

Fri, 16 Dec 2016 10:19:43 GMT

thnks for ur reply... rowno() is working...