topic Re: GetField selection with Multiple IF Statement in QlikView

GetField selection with Multiple IF Statement

qliklearnervir — Thu, 13 Aug 2015 06:40:02 GMT

Hi ,

I want to build an epression with multiple if where i want to select diffeent values and different outcome Like.

//IF(GetFieldSelections(WK) = '26',Date(Num(Today())+26*7,'DD/MM/YYYY'),'') OR

//IF(GetFieldSelections(WK) = '15',Date(Num(Today())+15*7,'DD/MM/YYYY'),'') OR

//IF(GetFieldSelections(WK) = '8',Date(Num(Today())+8*7,'DD/MM/YYYY'),'')

but OR Condition is not working .

I have created on1 list box with values like 26,15,8 and while click on 26 i want to manipulate out according to 26 and ame for 15 and 8....

please suggest......

MK_QSL — Thu, 13 Aug 2015 06:43:02 GMT

Something Like below

IF(GetFieldSelections(WK) = '26',Date(Num(Today())+26*7,'DD/MM/YYYY'),''),

IF(GetFieldSelections(WK) = '15',Date(Num(Today())+15*7,'DD/MM/YYYY'),''),

IF(GetFieldSelections(WK) = '8',Date(Num(Today())+8*7,'DD/MM/YYYY'),'')))

Check the ))) must be according to your IF

jonathandienst — Thu, 13 Aug 2015 06:47:28 GMT

Manish, I think you meant this:

IF(GetFieldSelections(WK) = '26',Date(Num(Today())+26*7,'DD/MM/YYYY'),

IF(GetFieldSelections(WK) = '15',Date(Num(Today())+15*7,'DD/MM/YYYY'),

IF(GetFieldSelections(WK) = '8',Date(Num(Today())+8*7,'DD/MM/YYYY'),'')))

Kushal_Chawda — Thu, 13 Aug 2015 07:08:26 GMT

may be like this

if(pick (match(GetFieldSelections(WK),'26','15','8'),

Date(Num(Today())+26*7,'DD/MM/YYYY'),

Date(Num(Today())+15*7,'DD/MM/YYYY'),

Date(Num(Today())+8*7,'DD/MM/YYYY')),'')

jonathandienst — Thu, 13 Aug 2015 07:23:07 GMT

You can simplify that further:

=If(Match(GetFieldSelections(WK),'26','15','8'), Date(Num(Today())+WK*7,'DD/MM/YYYY'))

qlikviewwizard — Thu, 13 Aug 2015 15:16:31 GMT

Did you get the answer?

qliklearnervir — Fri, 14 Aug 2015 10:45:06 GMT

yes

Ashutosh7777 — Thu, 15 Aug 2019 19:43:35 GMT

which one is working properly

thanks