topic Re: If Statement inside the Pick Function in QlikView

If Statement inside the Pick Function

mukesh19 — Tue, 20 Nov 2018 10:03:22 GMT

Hi All,

I tried using if statement inside the pick function but, fail to achieve it. My question is it possible to achieve the scenario.

Eg: =$(=pick(vtest,'var1',if(condition1,var2,var3)))

when I stored the if statement in variable its working fine. I have multiple statements storing each and every condition takes lot of time. Could anyone help to find the alternative solution.

Regards,

Mukesh

Re: If Statement inside the Pick Function

sunny_talwar — Tue, 20 Nov 2018 12:18:32 GMT

What exactly are var1, var2, and var3? Would you be able to share a sample where you can show the issue?

Re: If Statement inside the Pick Function

mukesh19 — Tue, 20 Nov 2018 13:06:23 GMT

Hi Sunny,
Thanks for the quick reply.
Vtest is the variable used for the button selection. values are assigned to the vtest as 1,2,3 etc.
Previously I used the expression like:
If(vtest=1,col1,
if(vtest=2, if(col2='A' or col2='B',col3))) and soo on based on number of button.

To optimize the nested if I tried to use the pick function as
=$(=pick(vtest,'col1',if(col2='A' or col2='B',col3))) but, if data is not getting displayed. when the condition is passed in variable its working fine
=$(=pick(vtest,'col1',vif)) where vif= if(col2='A' or col2='B',col3).

I would like to find the solution with out using variable

Re: If Statement inside the Pick Function

sunny_talwar — Tue, 20 Nov 2018 13:23:28 GMT

May be you need this

=$(=pick(vtest,'col1', $(vif)))

Re: If Statement inside the Pick Function

mukesh19 — Tue, 20 Nov 2018 14:00:27 GMT

using variable (vif) is working fine. I want to obtain the result with out using variable

Re: If Statement inside the Pick Function

sunny_talwar — Tue, 20 Nov 2018 14:08:05 GMT

I am a little confused here...

1) What is Col1 and Col2 and Col3? They are fields? Based on your if/pick condition, you want to get a particular field?

2) If 1) is true, then why is Col1 within single quotes and Col3 isn't?

=$(=pick(vtest,'col1',if(col2='A' or col2='B',col3)))

do you may be want col3 to be within single quotes also?

=$(=pick(vtest,'col1',if(col2='A' or col2='B','col3')))

This are things which can be easily seen through a sample. Right now all we know or see is what you are providing in your posts. Do you think you can post a sample so that we can see what you might have and what you need to get this fixed?