If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Assuming I have the following aggregated data:
To retrieve the maximum "# of objects" by date and hour, I'm using this expression:
It gives me the correct value (25), but I also want to find the relevant hour (09:00).
Can you assist me with this expression?
Thanks in advance,
this should do the trick
=firstsortedvalue(aggr([Hour (hh)],Date,[Hour (hh)]),-aggr(count(ObjecID),Date,[Hour (hh)]))
View solution in original post
על לא דבר