Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

% Symbal

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

1 Solution

Accepted Solutions
prahladind9
New Contributor III

Re: % Symbal

Hi,

I'm Using Qlik Sense.

Just go to data -> Number Formatting -->Custom---->> Format Pattern '##%'

That's it your data will appear with % endingline sheet.png

Hope this helps :-)

7 Replies
gautik92
Valued Contributor III

Re: % Symbal

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

arulsettu
Honored Contributor III

Re: % Symbal

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

Re: % Symbal

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

Capture.PNG

sureshqv
Esteemed Contributor III

Re: % Symbal

try to your measure

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

or


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

Not applicable

Re: % Symbal

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
New Contributor III

Re: % Symbal

Hi,

I'm Using Qlik Sense.

Just go to data -> Number Formatting -->Custom---->> Format Pattern '##%'

That's it your data will appear with % endingline sheet.png

Hope this helps :-)

elena_isupova
New Contributor III

Re: % Symbal

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:%form.png

Community Browser