6 Replies Latest reply: Mar 16, 2015 11:28 PM by Jonathan Poole

# Show non aggregated value in Guage

I have a simple sheet with 2 columns which has been exported into Qlik Sense Desktop

GEO   -  Sales

US          100

EU           50

Asia         10

I want 3 Guages to show sales for each GEO. I cant use the filter pane because it is global and will apply it to all guages.

if I drop the Sales measure into the Guage it only provide options for aggregation (SUM, Count etc.)

The only way I can get this to work is to add an expression to each guage .. If([GEO]='US',[Sales],0)

Is there a better way of doing this ?

• ###### Re: Show non aggregated value in Guage

Use these expressions:

sum({<GEO={'US'}>}Sales)

sum({<GEO={'EU'}>}Sales)

sum({<GEO={'Asia'}>}Sales)

• ###### Re: Show non aggregated value in Guage

OK. But there is no way to do this without expressions ?

• ###### Re: Show non aggregated value in Guage

Well you could sacrifice a goat and pray for divine intervention. But generally it's faster (not to mention less messy) to use an expression to calculate a result. Since you can only add an expression to a gauge, you will have to use an expression to calculate the result you need. In set analysis expressions you can determine which set of dimension values should be used to calculate the result.

• ###### Re: Show non aggregated value in Guage

OK. Thanks.

Follow up questions, what expression do I use to create a pie chart with specific GEOs .. lets say I only want US and APJ on the pie Chart not EMEA (and I dont want an others slice).

• ###### Re: Show non aggregated value in Guage

HI,

Try like this

=sum({<GEO={'US', 'APJ'}>}Sales)

The above expression will show only US and APJ.

Regards,

Jagan.

• ###### Re: Show non aggregated value in Guage

Set Analysis is probably the best way (as above) .

You can also use an IF() in the expression with or without match()

if(Geo='US' or Geo='APJ',Geo)

if( match(Geo,'US','APJ'), Geo)