topic Date Set Analysis & Variables in QlikView

Date Set Analysis & Variables

Mon, 22 Dec 2014 16:21:51 GMT

Hi,

I'm simply trying to create a variable that counts the number of ID's for 'Yesterday' :

count({<Date={'date(Today()-1)'}>}ID)

But this expression doesn't appear to be working....

The 'Date' field within my Dataset is in DD/MM/YYYY format if it helps.

Any help appreciated!

Tom

Gysbert_Wassenaar — Mon, 22 Dec 2014 16:36:41 GMT

Try count({<Date={"$(=date(Today()-1,'DD/MM/YYYY'))"}>}ID)

Anonymous — Mon, 22 Dec 2014 16:47:12 GMT

Hi!

Try this:

=count (distinct{<Your_date_field={"$(=date(Today()-1,'DD/MM/YYYY'))"}>} ID)

Hope it helps.

Gabriel

ecolomer — Mon, 22 Dec 2014 21:27:15 GMT

Try this:

COUNT({<Date={"$(=date(Today()-1))"}>}ID)