topic Value as Text in Graph in QlikView

Value as Text in Graph

fred_s — Tue, 08 Dec 2009 22:04:34 GMT

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

Value as Text in Graph

Wed, 09 Dec 2009 03:02:01 GMT

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'?

Value as Text in Graph

fred_s — Wed, 09 Dec 2009 20:18:40 GMT

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

Value as Text in Graph

fred_s — Fri, 11 Dec 2009 21:58:20 GMT

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

Value as Text in Graph

matt_crowther — Fri, 11 Dec 2009 23:43:11 GMT

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

Value as Text in Graph

fred_s — Tue, 15 Dec 2009 16:14:26 GMT

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

Thanks a lot Matt!