topic Re: Expression not working in QlikView

Expression not working

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

Hi all

I am using below expression

Count({<DateNum*={">=$(=vStartDate)<=$(=vEndDate)"}>}[ID])

total id's count am showing but when I filter

status=yes or no

the values are not reflecting

if I select yes the values should be zero instead of that it is showing some values.

prma7799 — Mon, 29 Jan 2018 09:15:47 GMT

try this

=Count({<DateNum={'>=$(vStartDate)<=$(vEndDate)'}>}[ID])

shiveshsingh — Mon, 29 Jan 2018 09:49:34 GMT

Count({<DateNum={">=$(=vStartDate)<=$(=vEndDate)"}>}[ID])

arvind1494 — Mon, 29 Jan 2018 09:51:20 GMT

Count({<DateNum={">=$(=vStartDate)<=$(=vEndDate)"}>}[ID])

soniasweety — Mon, 29 Jan 2018 09:56:56 GMT

not working

soniasweety — Mon, 29 Jan 2018 09:57:10 GMT

not working

arvind1494 — Mon, 29 Jan 2018 09:58:31 GMT

Count({<DateNum={">=$(vStartDate)<=$(vEndDate)"}>}[ID])

prma7799 — Mon, 29 Jan 2018 11:54:33 GMT

What error you are getting