topic Re: Error in expression in QlikView

Error in expression

ashmitp869 — Wed, 14 Jul 2021 06:15:11 GMT

Hi there,

Please kindly assist me with the below expression, I am getting Expression error

Count({<Identifier={'T','R','L'},[Ward Episode End Date.FinancialYear]={'$(=Max([Ward Episode End Date.FinancialYear])'},[Ward Episode End Date.MonthYear]={'$(=Max([Ward Episode End Date.MonthYear])'}>}[Total Ward Episodes] )

Thanks

Re: Error in expression

avinashelite — Wed, 14 Jul 2021 06:22:16 GMT

i don't see any error the syntax , may the issue is with the field names ? share the app so that we could check more

Re: Error in expression

kaushiknsolanki — Wed, 14 Jul 2021 06:49:17 GMT

Hi,

You are missing a few parentheses.

Count({<Identifier={'T','R','L'},[Ward Episode End Date.FinancialYear]={'$(=Max([Ward Episode End Date.FinancialYear]))'},[Ward Episode End Date.MonthYear]={'$(=Max([Ward Episode End Date.MonthYear]))'}>}[Total Ward Episodes] )