Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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.

View solution in original post

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...!