Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Make label values nice on combo chart

I am trying to make labels look nicely use friendly on a combo chart.

I have set the Y-axis like this

Where the full Max expression is

= ceil (

Count( distinct Asset) * 1.1 ,

num ( '1' & repeat ( 0 , if ( len(Count( distinct Asset) ) = 1 , 1 ,len(Count( distinct Asset) ) -1 ) ) )

)

This generally works quite nicely, but when (Count( distinct Asset) ) resolves to 62 then the labels show at non uniform intervals  as 0, 20 , 40 & 70.

Ideally I would like the labels at uniform intervals, as in  0, 20 , 40, 60 & 80.

Anybody got any cunning suggestions ?

Community Browser