Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Associating data to time frames (Last 24 Hours, Today, Last 30 Days, etc)

I'm querying in incident data and the incident created on time stamp.  During load I want to associate my data with their appropriate time frames.  Example: if an incident was created today it would belong to last 24 hours, today, and last 30 days but if an incident was created a week ago it would only belong to last 30 days.  Is there a way to loop through the data and create a second table that tracks the incident number and the multiple time frames it should appear in when selected?

1 Reply