topic Re: Conditional Expression: in QlikView

Conditional Expression:

EBabalola — Tue, 15 Dec 2020 00:29:09 GMT

Hello All

Please I need help with this expression

if(ValueList('[Is Patient on a St]', 'No')='No', Count({<[Chol range]={'5.1 - 6 mmol/L'}>}[Chol range]))

I have tried that to get only the Chol Range where Is Patient on a St is No.....It did not work

MayilVahanan — Tue, 15 Dec 2020 00:52:34 GMT

is [Is Patient on a St] field?? if so, try like below

Count({<[Chol range]={'5.1 - 6 mmol/L'}, [Is Patient on a St] = {'No'}>}[Chol range])

EBabalola — Tue, 15 Dec 2020 01:00:49 GMT

Thank you so Much.....It is 100% perfect.

MayilVahanan — Tue, 15 Dec 2020 01:19:49 GMT

Can you close the thread by marking correct answer.