topic Re: Forced 0 property does not work in QlikView

Forced 0 property does not work

shyamcharan — Wed, 03 Aug 2016 08:13:48 GMT

Hi experts,

I do have a chart as in the attached document.

I have unchecked the Forced 0 property to make the line in the chart display using minimum Y axis scale.

Something like between 60000 as starting point and to the maximum value.

I know this can be done using the Min Static option on the Axis tab. However, wondering why the Forced 0 Property does not work.

Any idea?

Thanks in advance for your help.

Regards,

Shyam.

Frank_Hartmann — Wed, 03 Aug 2016 08:44:30 GMT

have alook at the attached sample.

hope this helps

sunny_talwar — Wed, 03 Aug 2016 08:59:09 GMT

I think one of your expression is not giving any value which is causing the forced 0 unchecked to not work as we would expect it to work

shyamcharan — Wed, 03 Aug 2016 08:59:49 GMT

Hi Frank,

Thanks heaps for the response. It is smart.

However, the display of two axis might look confusing to the end user.

I really if you have any better ideas.

Thanks a ton for your help and support.

Regards,

Shyam.

Frank_Hartmann — Wed, 03 Aug 2016 09:14:24 GMT

another solution could be seen in the attached sample

shyamcharan — Thu, 04 Aug 2016 03:13:32 GMT

Thanks heaps Frank. It helped.