Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
morenoju
Partner
Partner

Today() in Set Analysis

Hello all,

This should be an easy one, but no matter how I write the Today() condition in this set analysis expression, I end up having a blank chart: I want to show the average verification time for events with a certain status (31) and that started today.

I've tried several alternatives, with no luck:

Avg({<start_date={"Today()"},event_status_id={'31'}>}verification_time)

Avg({<start_date={$(=Date(Today(), 'MM/DD/YYYY'))},event_status_id={'31'}>}verification_time)

If I write the date, it does work:

Avg({<start_date={"11/22/2017"},event_status_id={'31'}>}verification_time)

Any idea on what might be wrong with Today()? This seems like a syntaxis issue, but I can't see what the mistake is.

Thanks,

Juan

1 Solution

Accepted Solutions
sunny_talwar

Try this

Avg({<start_date={"$(=Date(Today(), 'MM/DD/YYYY'))"}, event_status_id={'31'}>} verification_time)

View solution in original post

4 Replies
sunny_talwar

Try this

Avg({<start_date={"$(=Date(Today(), 'MM/DD/YYYY'))"}, event_status_id={'31'}>} verification_time)

morenoju
Partner
Partner
Author

Works! Thank you, Sunny.

One thing I'm noticing though. Today() is returning yesterday. I've used KPIs and they show the following:

Today()=11/21/2017 (yesterday)

Today(0)=11/22/2017 (today)

Now()= 11/22/2017 1:51:13 PM


I've checked the date in the PC is right and I've just done a data load. Any reason for Today() to return 11/21?

sunny_talwar

I am not sure why it might be doing this....

morenoju
Partner
Partner
Author

I'll open a new question for that. In any case, you answered the original question right. Thanks for your help!