Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

antonybi
Contributor

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

Re: need help for If condition

My bad, I missed the $ sign

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

4 Replies

Re: need help for If condition

May be this

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

antonybi
Contributor

Re: need help for If condition

Thanks Sunny for the quick response.

 

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

 

PFB for your reference.Capture3.JPG

Re: need help for If condition

My bad, I missed the $ sign

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

antonybi
Contributor

Re: need help for If condition

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!