Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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