7 Replies Latest reply: May 14, 2018 3:19 AM by Simon Gaudissart

# Dashboard creation

Hi!

I am new to clik sense desktop and I am facing some issues :

My excel data has a dimension called "Domain", this dimension is composed of 8 different string values

I want to create a dashboard with 8 gauges. These gauges all have the same measure (Avg(grade)) but I need them to calculate it for the 8 different values of my domain (one for each). I cannot use a filter because I want all the gauges to show their values at the same time on the same sheet (like a dashboard).

I'm sur some kind of coding in the expression case condition of each gauge must work but I have no idea how.

Thanks a lot!

Simon

• ###### Re: Dashboard creation

If you make Domain your Dimension and then use your measure you will automatically get the values calculated per dimension value.

• ###### Re: Dashboard creation

Hi Mark,

Thanks for taking the time to answer,

I don't fully understand your idea "if you make Domain your dimension". When you in sert a gauge in clik sense desktop, you can only add a measure and no dimension...

Thank you

Simon

• ###### Re: Dashboard creation

Sounds like you need to use set analysis and create 8 chart one per domain.

Best regards

Andy

Simple example attached with just 2 gauges

• ###### Re: Dashboard creation

Thanks Andy, i'll take a look at set analysis then;

I solved my problem by creating a new table with a proper layout in Excel but I wanted to check if it was possible to reach the same result only in clik sense.

• ###### Re: Dashboard creation

I believe there is a trellis extension in qlik branch you can use to generate the gauge per dimension value. I'd look there for your solution. Set analysis although will work will need maintaining each time you add or remove a value.

Regards

Andy

• ###### Re: Dashboard creation

Hi Simon,

The answer of Andy it rights. You can create 8 separate gauge charts.

Each chart has a different measure:

The '1' means: ignore all selections. the <> means: calculate only for this domain.

The suggested \$ is also OK when the gauge chart should react on other filters.

• ###### Re: Dashboard creation

Thank you ! I will try all this

Thanks for the tips

• ###### Re: Dashboard creation

Works perfectly indeed,

Thanks again