topic Re: Bench marking? in QlikView

Bench marking?

Wed, 25 Nov 2020 16:16:04 GMT

Hey I want to know how I can keep one value (Name) from a field and show the comparisons to other values without showing the one that is selected and if possible how I can make these selections using an input box as that has left me confused.

Thanks for any help in advance.

ಸ‿ಸ

Re: Bench marking?

sunny_talwar — Fri, 22 Apr 2016 10:42:21 GMT

Not sure I completely understand, can you may be elaborate?

Re: Bench marking?

Fri, 22 Apr 2016 10:52:45 GMT

Well my aim is bench marking and I have a chart in which I want to compare the values to other values in the field which are the dimensions. The dimension is called "Name" and I also have an input box which makes selections but instead of showing just the one selection I want the opposite which is showing everything else.

Re: Bench marking?

swuehl — Fri, 22 Apr 2016 12:47:11 GMT

You could use alternate states for this.

Create an alternate state in Settings - Document properties - General tab (e.g. called AS).

Then create two list boxes for your Name dimension, one set to AS alternate state.

Select the benchmark name in AS, the peer group in the other list box.

Create a chart with dimension Name, set to default state.

Two expressions:

=Sum(Value) //or whatever you want to aggregate

= Sum(Value) / Sum({AS} TOTAL Value) //show comparison to benchmark

Re: Bench marking?

Fri, 22 Apr 2016 13:36:57 GMT

Hey thanks for the help unfortunately I have had to do something else but I will use this for later projects