Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Contributor III
Partner - Contributor III

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 🙂

View solution in original post

7 Replies
gautik92
Specialist III
Specialist III

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

arulsettu
Master III
Master III

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

sunny_talwar

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

Capture.PNG

Chanty4u
MVP
MVP

try to your measure

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

or


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

Not applicable
Author

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

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 🙂

Anonymous
Not applicable
Author

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