Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

My bad, I missed the $ sign

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

View solution in original post

4 Replies
Highlighted

May be this

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

Highlighted
Creator
Creator

Thanks Sunny for the quick response.

 

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

 

PFB for your reference.Capture3.JPG

Highlighted

My bad, I missed the $ sign

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

View solution in original post

Highlighted
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!