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

Reference Line not being visible as scale of Y axis is less than the reference line value

My reference line value is more than the the y axis scale . As its sets automatically the scale . So i could not make my reference line visible.

The scale is at 400 on y axis of the value.. And the reference line goes to value of 860 which is greater than the value 400 . So

plz suggest on this problem.

1 Reply
sbaldwin
Partner - Creator III
Partner - Creator III

Hi, what you would need to do is to use a static max in the axix tab using a formula like

=if( max(aggr( sum({$} Expression1), Dim1))>860,max(aggr( sum({$} Expression1), Dim1))*1.2,860*1.2)

I have attached an EG.

Thanks

Steve