Show non aggregated value in Guage

[#1]

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 ?

[Gysbert_Wassenaar]

Use these expressions:

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

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

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

[#3]

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

[Gysbert_Wassenaar]

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.

[#5]

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

[jagan]

HI,

Try like this

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

The above expression will show only US and APJ.

Regards,

Jagan.

[JonnyPoole]

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)

(and suppress nulls under 'addons')

But its just variations on a theme.