Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
danters182
Contributor II
Contributor II

Firstsortedvalue with max and set analysis

Hi,

I am currently struggling with showing the date assigned to my cycling stats:

I used max(MaxSpeed) and firstsortedvalue(datum,-MaxSpeed) for showing the date of my top speed in the textbox, which works fine.

For the average speed, I want to add a set analysis that I only take tours longer than 50km (as the set analysis works in the table) 

It also works with 
=max({$<Distanz={">=50"}>}[Durchschn.Geschw.])&' Km/h
for the key figure, but how can I show the assigned date?

Thanks for your help!


stats.jpg

1 Solution

Accepted Solutions
sunny_talwar

This

firstsortedvalue({$<Distanz={">=50"}>} datum,-MaxSpeed)

View solution in original post

2 Replies
sunny_talwar

This

firstsortedvalue({$<Distanz={">=50"}>} datum,-MaxSpeed)
danters182
Contributor II
Contributor II
Author

Works perfectly.

Thanks!