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
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
Labels
Test.qvw
459 Views
0 Likes
0 Replies