Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Dimension based on Time Interval

Hi all,

I need to create a straight table with a timestamp as dimension.

The catch is that the table gets extremely large if I report on every timestamp.

I spoke to my users and they asked for 2 tables based on a variable called vInterval which is the timeinterval in seconds

The 1st table must only report on the 1st possible value after the time specified in the interval and ignore all results in between

The 2nd report must do the same but also report the values in between.

I must do this in the frontend and not the load script.

The expression in the report just check for a value and the prints a 'X' if found else blank

See the attached example where the interval is set to 60 minutes

0 Replies