Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
After
Hi,
Divide by 100 to the expression and tick 'Show In Percent' under the 'Number' option.
Regards,
Jagan.
Hi,
Divide by 100 to the expression and tick 'Show In Percent' under the 'Number' option.
Regards,
Jagan.
Hi,
Is it working?
Regards,
Jagan.
It's working. But not sure why do we need this for adding just a symbol??
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.
Thanks for your clear explanation Jagan...!