Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
trishita
Contributor III

What is wrong with my syntax?

if (Match([HPV-Makroname],'HPPD'), [Manager],
if (Match([HPV-Makroname],'HPPI AI'), [Manager],

[Manager HPV]))

6 Replies

Re: What is wrong with my syntax?

Looks okay, what is the issue?

trishita
Contributor III

Re: What is wrong with my syntax?

error in expression..
here manager and manager hpv are dimensions...
So if HPV MAKRONAME is HPPD or HPPI AI it will show Manager Name or else Manager HPV.
But showing error in expressions

Re: What is wrong with my syntax?

Can you show an image of the error message that you see... I don't see any problem with what you shared

Channa
Valued Contributor III

Re: What is wrong with my syntax?

if (Match([HPV-Makroname],'HPPD','HPPI AI'), [Manager],
[Manager HPV])

Channa
trishita
Contributor III

Re: What is wrong with my syntax?

HPPD.JPG

Channa
Valued Contributor III

Re: What is wrong with my syntax?

=IF(WildMatch( COUNTRY_NAME_EN,'ALBANIA','ALGERIA'),COUNTRY_NAME_AR,COUNTRY_NAME_EN)

i am using this in my APP it works

if (WildMatch([HPV-Makroname],'HPPD','HPPI AI'), [Manager],[Manager HPV])

Channa