Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count of Ids based on 2 dates in One table

Hi

I have 2 dates in my table created date and resolved date, i need to count the keys created by week and resolved by week .. i can do something like this in script and use event type as indicator to filter out resolved and created , but is there any other simplified way to get this done instead of touching existing sql in the application ?

SELECT "create_ts" AS "EventDate",

  "key" AS "key",

'Created' as "EventType"

FROM Table

UNION

SELECT "resolution_date_key",

  "key" AS key",

  'Resolved' as "EventType"

FROM Table

Thanks

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

This looks like the right approach to me. I don't see a simpler way that won't complicate other things.


talk is cheap, supply exceeds demand