Discussion board where members can get started with QlikView.
I need your quick solution on this below if condition as its not working as expected.
Suggest if I'm anything wrong.
Look forward for your quick response.
Go to Solution.
My bad, I missed the $ sign
If('$(KPI_RAG1)' = 'NA', 1, 0)
May be this
If('(KPI_RAG1)' = 'NA', 1, 0)
Thanks Sunny for the quick response.
But still It's not working. expected result is 1.
PFB for your reference.
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.