Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sgaudiss
New Contributor II

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).

Can anyone help me please?

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

Tags (1)
8 Replies
rittermd
Honored Contributor

Re: Dashboard creation

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

sgaudiss
New Contributor II

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

awhitfield
Esteemed Contributor

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

sgaudiss
New Contributor II

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.

ogster1974
Honored Contributor II

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

heij1421
New Contributor III

Re: Dashboard creation

Hi Simon,

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

Each chart has a different measure:

Instead of using "Avg(grade)" you need to add the domain within the measure:

gauge chart 1:=Avg({1<Domain='A'>}grade)

gauge chart 2:=Avg({1<Domain='B'>}grade)


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.

sgaudiss
New Contributor II

Re: Dashboard creation

Thank you ! I will try all this

Thanks for the tips

sgaudiss
New Contributor II

Re: Dashboard creation

Works perfectly indeed,

Thanks again

Community Browser