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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies