topic Reference Line Label Format in App Development

Reference Line Label Format

sgagliardi — Mon, 20 Dec 2021 21:38:40 GMT

I am finding that on reference lines added to my line chart visualization that negative numbers are being displayed wrapped in 2 sets of parentheses, and positive numbers are being displayed wrapped in a single set of parentheses. I would prefer that positive numbers were formatted without parentheses, and negative numbers be wrapped in a single set of parentheses, though, I am open to displaying negative values with a minus sign in front of them in place of the parenthesis formatting. Efforts to reformat with a num() function have so far been unsuccessful. Might anyone in the community have insight into this?

Re: Reference Line Label Format

y_grynechko — Thu, 31 Oct 2019 18:52:39 GMT

I don't think you can get rid of the brackets. The solution you can work with is changing number format in the chart measure to something like this:

To get this:

Re: Reference Line Label Format

sgagliardi — Thu, 31 Oct 2019 19:09:49 GMT

Thanks y_grynechko, this should suffice as a solution to my problem. Would be great if I could keep parentheses on the measure and only format the reference line, but as you described, this is not currently possible in Qlik Sense. Thank you for your help!