Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
kothakas
Contributor III
Contributor III

Adding string literal to a measure on line chart

Hi,

I have a line chart that looks like this.

Percent.PNG

I want to append the string literal '%' to all the values on the line chart. Ex: -153.96 must become -153.96%. 44.2 must become 44.2%.

The values are coming from a measure as seen below

Percent Measure.PNG

How can I make this happen?

Thanks!

1 Solution

Accepted Solutions
kothakas
Contributor III
Contributor III
Author

I figured it out.

Percent Answer.PNG

View solution in original post

4 Replies
vvira1316
Specialist II
Specialist II

Hi,

Have you tried following

Number formatting and selecting %

Percentage.JPG

kothakas
Contributor III
Contributor III
Author

I figured it out.

Percent Answer.PNG

View solution in original post

aarkay29
Specialist
Specialist

you can use either custom formatting by simply adding '%' at the end or

change the exp to  num(netmargin/100,'##.#0%')

kothakas
Contributor III
Contributor III
Author

This does not work. When I do this, the value is getting displayed as 15396.00% instead of 153.96%.