Qlikview Ring chart with dual(replace()) function

[Anonymous]

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]

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 · Accepted solution]

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

[sunny_talwar]

Not asking for your expression a sample qvw

Preparing examples for Upload - Reduction and Data Scrambling