Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Orsok
Contributor
Contributor

Error in expression: If takes 2-3 parameters. Help!

I need help with this I'm pretty new to Qlik.

My problem, after the third if statement i got the error if take 2-3 parameters

if(match(ELZ,'X'),'Geliefert',
if(Liefetermi < Today(),(ELZ),'Offen',
if(Liefrtermi > Today(),(ELZ),'Überfällig',)))

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi

If takes only true or false statment based on condition.

if(match(ELZ,'X'),'Geliefert',
if(Liefetermi < Today(), (ELZ), 'Offen', --> in this statement, true part is ELZ & false part is offen so it won't allow to process below statement 
if(Liefrtermi > Today(),(ELZ),'Überfällig',))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

Hi

If takes only true or false statment based on condition.

if(match(ELZ,'X'),'Geliefert',
if(Liefetermi < Today(), (ELZ), 'Offen', --> in this statement, true part is ELZ & false part is offen so it won't allow to process below statement 
if(Liefrtermi > Today(),(ELZ),'Überfällig',))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.