Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
kothakas
New 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
Highlighted
kothakas
New Contributor III

Re: Adding string literal to a measure on line chart

I figured it out.

Percent Answer.PNG

View solution in original post

4 Replies
vvira1316
Valued Contributor II

Re: Adding string literal to a measure on line chart

Hi,

Have you tried following

Number formatting and selecting %

Percentage.JPG

Highlighted
kothakas
New Contributor III

Re: Adding string literal to a measure on line chart

I figured it out.

Percent Answer.PNG

View solution in original post

aarkay29
Valued Contributor

Re: Adding string literal to a measure on line chart

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

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

kothakas
New Contributor III

Re: Adding string literal to a measure on line chart

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