Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-04-09 05:43 AM

problem with table - Aggr, Sum, Timestamp

Hi... I need some help with a table.

a.) first is there another way to reduce "All Timeszamps" to Max and delete the null-Values?

          (I already tried DISTINCT but it doesnt work and I already checked "hide null values")

b.) afterwards i want to calculate the time intervals between the 1st and 2nd Max-value (see time 1), between the 3rd and 4th (see time 2), and so on ..

     -->watch out they have to build the intervall with the next MAX value within the same status (see time 4)

Thank you for your advice

test.png

Test.qvw
280 Views
0 Likes
0 Replies