topic Re: Gauge Chart in QlikView

Gauge Chart

nihhalmca — Thu, 27 Feb 2014 06:19:27 GMT

Hi All,

I want to display value (10,500.50 in thousands) in Gauge chart.

However Gauge chart shows value as '10.500.50'

My Requirement : display ',' instead of '.' after '10' (as thousand separator).

Thanks,

Regards,

NiHhal.

Re: Gauge Chart

sundarakumar — Thu, 27 Feb 2014 06:22:30 GMT

Go no number tab and give comma in thousand seperator

-Sundar

Re: Gauge Chart

sunilkumarqv — Thu, 27 Feb 2014 06:30:51 GMT

Hi,

On chart properties number tab make Format Pattern format like this #,###0 Hope you get the solution

Re: Gauge Chart

jagan — Thu, 27 Feb 2014 06:40:04 GMT

Hi,

Try like this

=Num(Num(Replace(Left('10.500.50', Len('10.500.50') -3), '.', ',')) + Num(Right('10.500.50', 2)/100), '#,###.#0')

Regards,

Jagan.

Re: Gauge Chart

jagan — Thu, 27 Feb 2014 06:46:02 GMT

Hi,

Or simply this

=Num(Num#(Replace('10.500.50','.', ''), '#,###')/100, '#,###.#0')

Regards,

jagan.

Re: Gauge Chart

Thu, 27 Feb 2014 07:24:44 GMT

If you are using LED you won't get comma

Re: Gauge Chart

nihhalmca — Thu, 27 Feb 2014 07:50:11 GMT

Thanks for reply Sundarakumar.

I tried this way but not working

NiHhal.

Re: Gauge Chart

nihhalmca — Thu, 27 Feb 2014 07:51:56 GMT

Thanks for writing

But not working

NiHhal.

Re: Gauge Chart

nihhalmca — Thu, 27 Feb 2014 07:59:34 GMT

Hi Jagan, thanks for writing

Please let me know where can i paste this script ex: number tab or expression tab.

NiHhal.

Re: Gauge Chart

sundarakumar — Thu, 27 Feb 2014 08:16:59 GMT

Hi Nihhal,

if the Right part is ur problem, then it cannot be shown as comma.. better go for Left side representation..

-Sundar

Re: Gauge Chart

jagan — Thu, 27 Feb 2014 08:30:28 GMT

Hi,

Do it in expression and in Number tab just select Expression Default option.

Hope this helps you.

Regards,

Jagan.

Re: Gauge Chart

jagan — Thu, 27 Feb 2014 08:32:41 GMT

Hi,

Are you using LED option in Gauge chart? If yes then LED won't show you the , instead it will show you . Because it is not possible to represent , in LED. Instead you can try in textobject and try with some fonts.

Hope this helps you.

Regards,

jagan.

Re: Gauge Chart

jaygarcia — Thu, 27 Feb 2014 08:56:09 GMT

Hi Nihhal

You might get the same problem with other displays if you haven't define the ThousandSep and DecimalSep of the regional settings at the beginning of your script:

SET ThousandSep=',';

SET DecimalSep='.';

Hope it helps

Re: Gauge Chart

nihhalmca — Thu, 27 Feb 2014 09:58:41 GMT

Hi Jay, Thanks for reply.

I tried your way but not working moreover already Number tab show decimal= '.' and thousands= ','

Most probably it is not possible in LED style at Gauge chart.

NiHhal.

Re: Gauge Chart

jagan — Thu, 27 Feb 2014 10:02:33 GMT

Hi Nihhal,

It is not possible in LED Gauge chart, use Text object and use font styles to imitate the LED style.

Regards,

Jagan.