Giving numbers a reference point

[#1]

I am building a dashboard where I want to show the average of a measure for the particular dimension I have selected on.  But I also want to put that number in context by showing it for the whole business so that a comparison can be made.  Is this possible.

To explain further, we have average premium by broker, and I want to pick one broker and show most of my dashboard relative to this broker, but also give them numbers some context by showing some figures across all brokers

[#2]

Actually I think I have managed to do this by breaking the link to the master dimension.  Is that the right way to do it?

[Oleg_Troyansky]

Why not use Set Analysis {1} for the comparison calculations, to ignore all selections? Or, use Set Analysis with specific modifiers to ignore just some of the selections?

cheers,

Oleg Troyansky

Come and learn Set Analysis and Advanced Aggregation with me at www.masterssummit.com - take your QlikView skills to the next level!

[#4]

Hi, thanks - I'm not sure if you can get at the set analysis in qlik sense and customise it enough - was your answer in reference to qlikview?  sorry I'm very new to this

[#5]

Put some information in excel o write yours tables for help you...

Regards!!!

[Anonymous]

with set analysis {1} you can ignore selections but dimensions will be still taken into account.

[Michael_Tarallo · Accepted solution]

Hi Alastair - Oleg is correct.

Using Set Analysis for a Measure - which you can define both in the Chart object expression AND/OR as a Measure in the master items.

For example: Avg({1-$}Sales) - Will give you average sales for all other Sales Excluding the current selection.

See the example app - copy to C:\Users\<user profile>\Documents\Qlik\Sense\Apps  and refresh the Qlik Sense Desktop by pressing F5

Please mark the appropriate replies as correct or helpful so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[Michael_Tarallo]

Here is a great tool that will help build a Set Analysis Expression for you as well

Set Analysis Wizard for QlikView | qlikblog.at

Mike

[Oleg_Troyansky]

Just to clarify - Set Analysis logic equally applies to QlikView and Qlik Sense.

[#10]

What is the syntax for using set analysis with specific modifiers?  Thanks for all the help!