Force 0 on Continuous line chart when expression is Avg( )

MattG — Thu, 28 Mar 2024 04:21:00 GMT

Hi all,

I have a line chart over a continuous x-axis that I want to drop to zero when no data exists for that time value.

If my query is a SUM, then this is fine by using + SUM({1}0)

My problem is that for this chart I am using an AVG function.

I've tried +AVG({1}0) but this didn't work.

Has anyone found a solution to this problem before?

Re: Force 0 on Continuous line chart when expression is Avg( )

marcus_sommer — Thu, 28 Mar 2024 11:40:25 GMT

You may try: rangemax(0, avg(FIELD))

topic Re: Force 0 on Continuous line chart when expression is Avg( ) in QlikView

Force 0 on Continuous line chart when expression is Avg( )

Re: Force 0 on Continuous line chart when expression is Avg( )