% Symbal

[#1]

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

[gautik92]

click on the expression and check on the Relative option in Expression tab

[arulsettu]

properties->number->integer then enable show in percentage

[sunny_talwar]

Change the settings on the number tab to check 'Show in Percent (%)'

[Chanty4u]

try to your measure

=num(sum(Sales)/sum(total Sales),'%')

or

=num(sum(Sales)/sum(total Sales),'0%')

[#6]

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

[prahladind9 · Accepted solution]

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 🙂

[Anonymous]

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: