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: 
Not applicable

% Percentage Symbol in the chart

Dear all,

I wanted to add the % in my chart. when i tick 'Show In Percent' under the 'Number' option. The symbol shown but the value changed as well.

Before

before.png

After

after.png

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Divide by 100 to the expression and  tick 'Show In Percent' under the 'Number' option.

Regards,

Jagan.

View solution in original post

5 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Divide by 100 to the expression and  tick 'Show In Percent' under the 'Number' option.

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Is it working?

Regards,

Jagan.

Not applicable
Author

It's working. But not sure why do we need this for adding just a symbol??

jagan
Luminary Alumni
Luminary Alumni

Hi,

When you are selecting Show Pecentage option in Number tab of Chart Properties, internally Qlikview multiplies into 100 and displays in percentage.   So, to cancelling that multiplication we are dividing the value by 100.

=((Actual Value) * Qlikview % Multiplication) / 100 = Actual Value

Hope it helps you.

Regards,

Jagan.

Not applicable
Author

Thanks for your clear explanation Jagan...!