topic Re: Requirement on if condition in QlikView

Requirement on if condition

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys

i have implemented this if condition but it showing error.could you please help me out on this

if(Product='Two Wheelers' and Level='Level1','Test3',

if(Product='Three Wheelers' and Level='Level1','Test4,

if(item='gear' and id=2 ,'Test1',

if(item5='clach' and pid=7, 'Test2')))) as New_Skill,

Thanks,

Siddik

trdandamudi — Tue, 03 May 2016 16:47:34 GMT

What is the error you are getting ? Can post it here please.

Clever_Anjos — Tue, 03 May 2016 16:53:59 GMT

You are missing a ' after Test4

Chanty4u — Tue, 03 May 2016 16:55:20 GMT

try this

if(Product='Two Wheelers' and Level='Level1','Test3',

if(Product='Three Wheelers' and Level='Level1','Test4',

if(item='gear' and id=2 ,'Test1',

if(item5='clach' and pid=7, 'Test2')))) as New_Skill,