Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have line chart Year and Values.Now i want to display this values with % symbal.
How can i add % symbal with values.
Thanks
Govind R
Hi,
I'm Using Qlik Sense.
Just go to data -> Number Formatting -->Custom---->> Format Pattern '##%'
That's it your data will appear with % ending
Hope this helps 🙂
click on the expression and check on the Relative option in Expression tab
properties->number->integer then enable show in percentage
Change the settings on the number tab to check 'Show in Percent (%)'
try to your measure
=num(sum(Sales)/sum(total Sales),'%')
or
=num(sum(Sales)/sum(total Sales),'0%')
Dear Friends,
I am using qlik sense. Not Qlik View.
My chart having 2 values
Year and total growth
Total formulae:
((sum(Expense_GL)-RangeSum(Above(sum(Expense_GL))))/RangeSum(Above(sum(Expense_GL))))\
Now i want to display with % .
Hi,
I'm Using Qlik Sense.
Just go to data -> Number Formatting -->Custom---->> Format Pattern '##%'
That's it your data will appear with % ending
Hope this helps 🙂
Change number formatting for this measure: instead of Auto use Number.
Then use Custom Formatting. Put a "%" sign in the end of Format pattern like: