Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
MichalSa
Contributor II
Contributor II

Count how many cases are assigned within 24h

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!!

 

2 Replies
PrashantSangle

can you explain with sample data.??
Great dreamer's dreams never fulfilled, they are always transcended.
Sergio3
Partner
Partner

What you have in [Created]? TImestamp?

Try this:

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