Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlikview Ring chart with dual(replace()) function

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

3 Replies
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
Not applicable
Author

=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