topic Re: Count on a table, filtering by date and time is a variable in QlikView

Count on a table, filtering by date and time is a variable

Mon, 27 Apr 2015 16:09:50 GMT

Hi, I have a problem that does not make me the count and not to do wrong,

by the variable, vToday as Today

LET vToday = Today ();

statement:

= Count ({<DATE = {$ (= [vToday])}>} CANTIDADPREPARADA)

and gives me "Error: Error in set list element modifier ad hoc ',' or ')' expected.

Many thanks in advance.

Oscar

sunny_talwar — Mon, 27 Apr 2015 16:34:32 GMT

Try this instead:

=Count ({<DATE = {'$ (vToday)'}>} CANTIDADPREPARADA)

sunny_talwar — Mon, 27 Apr 2015 16:35:48 GMT

If this doesn't work, then you might have to format today in your variable

LET vToday = Date(Today());

HTH

Best,

Sunny

Mon, 27 Apr 2015 16:54:13 GMT

ok, perfect, thankssssssssssssssssssssssss

sunny_talwar — Mon, 27 Apr 2015 16:55:56 GMT

No problem