Qlik Community

Qlik Sense App Development

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

jerryr125
New Contributor III

Reference Lines on line chart - changing the value display

Hi - 

I have a line chart displaying a reference line using the following formula:

 

=Avg(aggr(sum(AMOUNT), [DATE]))

 

Question - when the value appears how do I remove the "( )" around the value ?

Example : the reference line is displaying "(10,000)" and I would like it to display "10,000"

 

thoughts ? Jerry

 

 

 

 

Tags (1)
3 Replies

Re: Reference Lines on line chart - changing the value display

Is this because it is a negative number? May be you need fabs to make it positive

=fabs(Avg(aggr(sum(AMOUNT), [DATE])))
jerryr125
New Contributor III

Re: Reference Lines on line chart - changing the value display

hi -  thanks for the reply - appreciate it!

The number is positive so it is displaying the ( ) for positive numbers.

 

thoughts ? Jerry

lukereeve89
New Contributor III

Re: Reference Lines on line chart - changing the value display

Hi Jerry,

Unfortunately I think this is how the reference lines are displayed and have nothing to do with the value it self - As far as I know this cannot be changed using stock charts.