Dimension based on Time Interval

joggiek — Tue, 05 Aug 2014 13:20:52 GMT

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

topic Dimension based on Time Interval in QlikView