Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Value as Text in Graph

I'd like to create a couple of Gauges, one per Sales manager, showing their sales results.

Dimension:

=SalesManager = 'Elvis'

Expression:

=Sum([xSales])

It's probably a really stupid question, but I can't find a way to show the value as 'Text in Chart". Text in Chart is no Problem, it's getting the value in there.

So the Sum of xSales for SalesManager='Elvis' in a Gauge

Any help will be appreciated.

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
Luminary
Luminary

Value as Text in Graph

Shouold be a simple solution:

Remove the dimension and enter the following as your Expression: =sum(if(SalesManager='Elvis',xSales))

Use the same with your 'Text in Chart' or even ='Elvis Sales: '&sum(if(SalesManager='Elvis',xSales))

That works in your example file and how I've used it in the past.

Hope that helps,

Matt

View solution in original post

5 Replies
Highlighted
Not applicable

Value as Text in Graph

Try something like this in the Text in Chart box on the Presentation tab.

='Sales by '&SalesManager&': '&Sum(xSales)

You need to select Elvis of course to get 'Sales by Elvis: [99999]'

Or did you want a hard-coded 'Elvis'?

Highlighted
Partner
Partner

Value as Text in Graph

Hi Mark,

Yep, i need a hard-coded Elvis.
I want to create a Gauge per SalesManager.

My Dimension for the the first Elvis Gauge:
=SalesManager = 'Elvis'

The second Gauge will probably be MichaelJackson:
=SalesManager = 'MichaelJackson'

The Needle is in the right position, but i can't get the value in the 'Text in Chart'.

Using "sum(xSales)" doesn't do anything with my 'Elvis Dimension'.

Highlighted
Partner
Partner

Value as Text in Graph

Attached a simple example.
The real file has no possibility to select a different SalesManager.

The Gauge has a hardcoded Dimension =SalesManager = 'Elvis'.

What i'd like to achieve is to show 1000000 (sales by Elvis) as 'Text in Chart', instead of 2775500.

Anyone?
plz

Highlighted
Luminary
Luminary

Value as Text in Graph

Shouold be a simple solution:

Remove the dimension and enter the following as your Expression: =sum(if(SalesManager='Elvis',xSales))

Use the same with your 'Text in Chart' or even ='Elvis Sales: '&sum(if(SalesManager='Elvis',xSales))

That works in your example file and how I've used it in the past.

Hope that helps,

Matt

View solution in original post

Highlighted
Partner
Partner

Value as Text in Graph


It might be a simple solution, but it's exactly what I was looking for.

Thanks a lot Matt!