topic Benchmark Set Analysis between Outlets in QlikView

Benchmark Set Analysis between Outlets

dominikkeller — Sat, 16 Nov 2024 19:53:27 GMT

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)

And my Selections

Any ideas to solve my Problem?

Re: Benchmark Set Analysis between Outlets

sunny_talwar — Wed, 16 Oct 2019 11:59:50 GMT

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?

Re: Benchmark Set Analysis between Outlets

dominikkeller — Wed, 16 Oct 2019 12:10:44 GMT

Hey Sunny,

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

My Goal instead will look this way

i hope you understand my weird thinking better now

Re: Benchmark Set Analysis between Outlets

sunny_talwar — Wed, 16 Oct 2019 12:15:53 GMT

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

Re: Benchmark Set Analysis between Outlets

dominikkeller — Wed, 16 Oct 2019 12:22:57 GMT

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.

Re: Benchmark Set Analysis between Outlets

sunny_talwar — Wed, 16 Oct 2019 12:35:17 GMT

May be this

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

Re: Benchmark Set Analysis between Outlets

dominikkeller — Wed, 16 Oct 2019 12:43:42 GMT

thank you!

unfortunately not

this is the result

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

Re: Benchmark Set Analysis between Outlets

sunny_talwar — Wed, 16 Oct 2019 12:47:14 GMT

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

Re: Benchmark Set Analysis between Outlets

dominikkeller — Wed, 16 Oct 2019 13:16:07 GMT

Of course

Re: Benchmark Set Analysis between Outlets

sunny_talwar — Wed, 16 Oct 2019 13:27:52 GMT

Try this

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

Re: Benchmark Set Analysis between Outlets

dominikkeller — Wed, 16 Oct 2019 13:42:43 GMT

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