Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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 ?

6 Replies

Re: Show non aggregated value in Guage

Use these expressions:

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

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

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


talk is cheap, supply exceeds demand
Not applicable

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.


talk is cheap, supply exceeds demand
Not applicable

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

MVP
MVP

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.



Employee
Employee

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)

(and suppress nulls under 'addons')


But its just variations on a theme.



Community Browser