topic Re: need help for If condition in QlikView

need help for If condition

antonybi — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

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.

Thanks,

sunny_talwar — Tue, 13 Aug 2019 19:36:46 GMT

May be this

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

antonybi — Tue, 13 Aug 2019 19:46:03 GMT

Thanks Sunny for the quick response.

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

PFB for your reference.

sunny_talwar — Tue, 13 Aug 2019 19:47:04 GMT

My bad, I missed the $ sign

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

antonybi — Tue, 13 Aug 2019 20:09:07 GMT

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!