Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Contributor III

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

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

Community Browser