Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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