Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

My bad, I missed the $ sign

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

View solution in original post

4 Replies

May be this

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

Creator
Creator

Thanks Sunny for the quick response.

 

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

 

PFB for your reference.Capture3.JPG

My bad, I missed the $ sign

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

View solution in original post

Creator
Creator

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!