Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date(Today()) in a Set-analys don´t work?

Hi

I´m trying to do a set analys to count the AKTID wich have today date in the ENDDATE-field

=Count({$<ENDDATE={$(=Date(Today()))}>}AKTID)

Why does it not work? Do I have to set a varaiable in the load or something?

/Thanks!

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Check with this

     =Count({$<ENDDATE={'$(=Date(Today()))'}>} AKTID)

Still you didn't get this then check whether your end date field is in timestamp format if so use like below

=Count({$<ENDDATE={'$(=TimeStamp(Date(Today())))'}>} AKTID)

Celambarasan

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Check with this

     =Count({$<ENDDATE={'$(=Date(Today()))'}>} AKTID)

Still you didn't get this then check whether your end date field is in timestamp format if so use like below

=Count({$<ENDDATE={'$(=TimeStamp(Date(Today())))'}>} AKTID)

Celambarasan

Not applicable
Author

Thanks! The first worked fine