topic Qlikview Ring chart with dual(replace()) function in QlikView

Qlikview Ring chart with dual(replace()) function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team

I have a ring chart where in my 3rd expression(size of ring) i am using dual function for displaying values on mouse hover pop-up over ring:

=dual('Net Margin:'&' ='&replace(num(sum(1000000/23),'#,##.0'),chr(44),chr(39)),replace(num(sum(1000000/23),'#,##.0'),chr(44),chr(39)))

It is working fine. But the size of the rings is becoming same after putting the above expression.

Also I have tried in Properties-> Number->Fixed To

My requirement is:

I want to show the numbers as 4'34'78.3 rather than 4,34,78.3

I want the size of the rings to be as per size and the values to display like 4'34'78.3 on mouse hover pop-up over ring

Please help

Thanks in Advance

sunny_talwar — Mon, 19 Jun 2017 11:03:39 GMT

May be use a separate expression for pop-up. Would you be able to share a sample to look at, if you continue to have trouble?

Anonymous — Mon, 19 Jun 2017 17:08:58 GMT

=dual('Net Margin:'&' ='&replace(num(sum(1000000/23),'#,##.0'),chr(44),chr(39)),num(sum(1000000/23),'#,##.0'))

sunny_talwar — Mon, 19 Jun 2017 17:11:48 GMT

Not asking for your expression a sample qvw