Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

syncronize line chart with minimun value

Hi to all,

i have a line chart and i want to synchronize the Y axis with the smallest value in the chart. I mean that if the minimun value is 1.000.000 i do not want the chart to start from 0 but from 1.000.000 in order to elininate the white space which is not used.

I have managed to do it with a line chart that calculates the amoun of some transactions but i cannot get the same result when i try to do the same with a line chart that calculates the transaction count.In both charts i have checked the "synchronize zero level for expression axes" and unchecked the "forced 0" and "log scale"in the axes tab and all null and zero values are excluded.

The charts are identical (they have the same properties) and the only thing that changes is the expresions (sum vs count). The count chart is a clone of the sum chart.The charts have 4 expressions with information about the 4 latest years.

Attached you will see find the 2 charts.

Any help will be very appreciated.

Thank you all in advance.

3 Replies
satyadev_j
Valued Contributor

Re: syncronize line chart with minimun value

Hi,

Have you tried setting Chart's Static Min scale?

limit_zero.PNG.png

Not applicable

Re: syncronize line chart with minimun value

Hi there,

Thank you for your reply. I cannot have static min since the displayed values can vary between a few thounsands up to 5 or 6 millions.

Thank you.

satyadev_j
Valued Contributor

Re: Re: syncronize line chart with minimun value

Hi,

You can make it dynamic min scale by using expression with Aggr() and Min() function. See attachment.

Thank you.

Community Browser