GetField selection with Multiple IF Statement

[qliklearnervir]

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]

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]

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]

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]

You can simplify that further:

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

[qlikviewwizard]

Hi qliklearnervir

Did you get the answer?

[qliklearnervir]

yes

[Ashutosh7777]

which one is working properly

thanks