Firstsortedvalue with max and set analysis

danters182 — Mon, 12 Aug 2019 12:25:54 GMT

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!

Re: Firstsortedvalue with max and set analysis

sunny_talwar — Mon, 12 Aug 2019 12:49:10 GMT

This

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

Re: Firstsortedvalue with max and set analysis

danters182 — Mon, 12 Aug 2019 13:10:03 GMT

Works perfectly.

Thanks!

topic Re: Firstsortedvalue with max and set analysis in QlikView

Firstsortedvalue with max and set analysis

Re: Firstsortedvalue with max and set analysis

Re: Firstsortedvalue with max and set analysis