Qlik Community

Ask a Question

New to QlikView

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

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Count how many cases are assigned within 24h


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



2 Replies

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

What you have in [Created]? TImestamp?

Try this:

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