Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
antonybi
Creator
Creator

need help for If condition

Hi All,

I need your quick solution on this below if condition as its not working as expected.

Capture2.JPG

Suggest if I'm anything wrong.

 

Look forward for your quick response.

 

Thanks,

 

 

1 Solution

Accepted Solutions
sunny_talwar

My bad, I missed the $ sign

If('$(KPI_RAG1)' = 'NA', 1, 0)

View solution in original post

4 Replies
sunny_talwar

May be this

If('(KPI_RAG1)' = 'NA', 1, 0)

antonybi
Creator
Creator
Author

Thanks Sunny for the quick response.

 

But still It's not working. expected result is 1.

 

PFB for your reference.Capture3.JPG

sunny_talwar

My bad, I missed the $ sign

If('$(KPI_RAG1)' = 'NA', 1, 0)

antonybi
Creator
Creator
Author

Hi Sunny,

 

Then I'm getting the below error.

 

Error: Error in expression ')' expected.

 

I think I forgot to add = in my variable. Now I did the same looks like working fine.

 

Thank you!