Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
joggiek
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