Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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)
1 Solution

Accepted Solutions
Highlighted

Re: Benchmark Set Analysis between Outlets

Try this

 

Sum(TOTAL <Kalendar.Wochentag> {<Filiale.Filiale>} Buchungen.Summe)/(Sum(TOTAL <Kalendar.Wochentag> {<Filiale.Filiale>} GX_Stunden_Ready.minutes)/60) * Avg(1)

 

Capture.PNG

 

View solution in original post

10 Replies
Highlighted

Re: Benchmark Set Analysis between Outlets

I am not completely sure I understand your requirement? Are you looking to ignore selection in Outlet? What was wrong when you ignored selection in Outlet after you used {<Outlet =>} in your expression?

Highlighted
Contributor III
Contributor III

Re: Benchmark Set Analysis between Outlets

Hey Sunny,

 

if i use '=' in the set analysis this happens

clipboard_image_0.png

 

My Goal instead will look this way

clipboard_image_1.png

i hope you understand my weird thinking better now

Highlighted

Re: Benchmark Set Analysis between Outlets

I am still not certain, I understand completely here... why do these value match up exactly? Is that by chance?

image.png

Highlighted
Contributor III
Contributor III

Re: Benchmark Set Analysis between Outlets

That was just a quick copy and paste placeholder in Excell.

In the first expression, it is calculated based on the selection.

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

 In the second formula (my problem) the AVG of all outlets of the same group.

Highlighted

Re: Benchmark Set Analysis between Outlets

May be this

If(Column(1) <> 0, Sum(TOTAL {<Outlet>} Buchungen.Summe)/(Sum(TOTAL {<Outlet>} GX_Stunden_Ready.minutes)/60))
Highlighted
Contributor III
Contributor III

Re: Benchmark Set Analysis between Outlets

thank you!

unfortunately not

this is the result

clipboard_image_1.png

and i need the values from total, just without displaying the other outlets

clipboard_image_0.png

Highlighted

Re: Benchmark Set Analysis between Outlets

It might be easier to help if you are able to share a sample to help you better here

Highlighted
Contributor III
Contributor III

Re: Benchmark Set Analysis between Outlets

Of course

Highlighted

Re: Benchmark Set Analysis between Outlets

Try this

 

Sum(TOTAL <Kalendar.Wochentag> {<Filiale.Filiale>} Buchungen.Summe)/(Sum(TOTAL <Kalendar.Wochentag> {<Filiale.Filiale>} GX_Stunden_Ready.minutes)/60) * Avg(1)

 

Capture.PNG

 

View solution in original post