Re: Count how many cases are assigned within 24h - Qlik Community

MichalSa · ‎2020-01-22

Hi

I need to count how many cases are assigned to a rep within 24 hours.
Default assignment is to "System Administrator" and I'm trying to count since the created date...

I'm trying:
=count (24 * ({$< [Assigned To] = {'System Administrator'}>} num(Interval(now() - [Created],'DD'),'##.#')) distinct [Case ID])

It's not working - so appreciate any help here.....

Thanks!!

PrashantSangle · ‎2020-01-22

can you explain with sample data.??

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Sergio3 · ‎2020-01-22

What you have in [Created]? TImestamp?

Try this:

count ({$< [Assigned To] = {'System Administrator'},[Created]={">=timestamp(now()-1)"} >} distinct [Case ID])