Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Set Analysis & Variables

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

3 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
gabriel_kirst
Creator III
Creator III

Hi!

Try this:

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

Hope it helps.

Gabriel

ecolomer
Master II
Master II

Try this:

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