topic Re: A simple gauge question in QlikView

A simple gauge question

Thu, 06 Mar 2014 15:21:34 GMT

I have built a gauge that is displaying some information from an SQL DB. Gauge looks good so far but I want the total # to live under the needle but I am not seeing how to make it display that. This is my first question on the community!

Re: A simple gauge question

Anonymous — Thu, 06 Mar 2014 15:25:35 GMT

You can use "Text in Chart", where text is the same expression as for the chart itself. You can move tis text in any place in the chart by using CTR+SHIFT and drag.

Re: A simple gauge question

Thu, 06 Mar 2014 15:28:42 GMT

What Total?

I think in your case you want to display 180?

Vinay

Re: A simple gauge question

Anonymous — Thu, 06 Mar 2014 15:30:06 GMT

Please use text in chart in presentation tab:

Re: A simple gauge question

Thu, 06 Mar 2014 15:35:46 GMT

You can use "Text in Chart", where text is the same expression as for the chart itself. You can move tis text in any place in the chart by using CTR+SHIFT and drag. (you need to "Reset User Sizing" & "Reset user Docking" first)

check above image

Re: A simple gauge question

Thu, 06 Mar 2014 15:38:06 GMT

Thanks Nitha P. Can you paste the text from Max and Text in chart? I am trying some of the other suggestions as well.

Re: A simple gauge question

Thu, 06 Mar 2014 15:43:07 GMT

Can you show me what you have in chart text to get the # to display? Thanks.

Re: A simple gauge question

Anonymous — Thu, 06 Mar 2014 15:44:57 GMT

Textbox value : =num(sum([Calls.Total Calls])/sum([Calls.Working Day]),'#,##0.0')

Max textbox value : max({1}[Calls.Total Calls])

Hope it helps

Re: A simple gauge question

Thu, 06 Mar 2014 15:49:50 GMT

It depend on your data but you can use something like...

sum({<Team={Team1}>}[Net Sales])

sum(Sales)

sum(qty)

Vinay

Re: A simple gauge question

Thu, 06 Mar 2014 15:59:31 GMT

Hi Mikel,

in oder to add the total value of the KPI you should add the expression (with the function for number formatting) in the section Text in Chart of the Presentation tab (as the 1st image attached), then you can resize or move the label clicking on it through the command Ctrl+Shift (and you can see the red borders as the 2nd image shows).

Re: A simple gauge question

Thu, 06 Mar 2014 16:12:34 GMT

Thanks. I really needed to see the syntax basically and can write it with my tables.

Re: A simple gauge question

Thu, 06 Mar 2014 17:08:46 GMT

Thanks everyone I got it working!