Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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
MVP
MVP

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
MVP
MVP

Hi,

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

Regards,

Jagan.

View solution in original post

jagan
MVP
MVP

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
MVP
MVP

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