Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dominikkeller
Contributor III
Contributor III

Benchmark Set Analysis between Outlets

Hey Guys,

im trying to build a benchmark expression.

My Goal is to display the AVG Productivity from all Outlets  from a Group. 

So i select a outlet and a timeframe and the avg should deselect the outlet but not the timeframe. 

If i do a set analysis with "Outlet=" my Outlet Dimension shows me all outlets.

This is my expression for the value of the selected Outlet: 

sum(Buchungen.Summe)/(sum(GX_Stunden_Ready.minutes)/60) 

clipboard_image_0.png

And my Selections

clipboard_image_1.png

Any ideas to solve my Problem?

Labels (2)
10 Replies
dominikkeller
Contributor III
Contributor III
Author

Thank you so much sunny. you are my man of the day!