Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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 (1)
10 Replies
dominikkeller
Contributor III
Contributor III
Author

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