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.
My bad, I missed the $ sign
If('$(KPI_RAG1)' = 'NA', 1, 0)
View solution in original post
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.