Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Conditional IF function in calculated field

Trying to create a field based on conditional information, however when I use the conditional "If" function, I receive the error that "=" is an unrecognized symbol (see attachment).  I have no issues creating similar fields in Tableau and Crystal, so not sure what I am doing wrong in Qlik (this is my first time using Qlik, so I am totally new with this product)

1 Solution

Accepted Solutions
lakshmikandh
Specialist II
Specialist II

Try this

If ( match ( [Pmt Message Category 1], '5' ) , 1, 0 )

View solution in original post

6 Replies
rupamjyotidas
Specialist
Specialist

If(PmtMessageCat=5,PmtMessageCat​) will be more appropriate.

or

If(PmtMessageCat='5',1,0​)

Anonymous
Not applicable
Author

Try this,

if(yourAge>='25','Youth','Teen')

lakshmikandh
Specialist II
Specialist II

Try this

If ( match ( [Pmt Message Category 1], '5' ) , 1, 0 )

Anonymous
Not applicable
Author

Brilliant, this worked!  Thank you very much!

Anonymous
Not applicable
Author

Unfortunately I still get the error message that the equals symbol is not recognized, thank you though!

psuser1
Contributor
Contributor

I tried this, but it didnt work. Any clues?

psuser1_0-1623978248414.png