Remove Null Line in Line Chart

[hamdaniahmad]

Hello All,

I have one questions, how to remove line in line chart, if value is null?

Please see picture which is in black box.

Thank you all.

[sunny_talwar]

What is the expression that you are using for Rslt Mar 2018?

[hamdaniahmad]

Hello Sunny,

Here's my expression for Rslt Mar 2018

sum({<Date_Fix={">=$(=MonthStart(AddMonths(max({<DESC= {'Sales'}>}Date_Fix),0)))<=$(=AddMonths(max({<DESC= {'Sales'}>}Date_Fix),0))"},tyear,tmonth,tdate>}sales_qty)

[sunny_talwar]

And is this doing full accumulation?

[hamdaniahmad]

Yess, comparing with last year with fully accumulation by month, problem is when this month didn't reach end of month, the line become straight with same value.

[sunny_talwar]

Remove 'full accumulation' and try one of these

RangeSum(Above(Sum({<Date_Fix = {">=$(=MonthStart(AddMonths(max({<DESC= {'Sales'}>}Date_Fix), 0)))<=$(=AddMonths(max({<DESC= {'Sales'}>}Date_Fix),0))"}, tyear, tmonth, tdate>} sales_qty), 0, RowNo()))

or

If(Sum({<Date_Fix = {">=$(=MonthStart(AddMonths(max({<DESC= {'Sales'}>}Date_Fix), 0)))<=$(=AddMonths(max({<DESC= {'Sales'}>}Date_Fix),0))"}, tyear, tmonth, tdate>} sales_qty) > 0,

RangeSum(Above(Sum({<Date_Fix = {">=$(=MonthStart(AddMonths(max({<DESC= {'Sales'}>}Date_Fix), 0)))<=$(=AddMonths(max({<DESC= {'Sales'}>}Date_Fix),0))"}, tyear, tmonth, tdate>} sales_qty), 0, RowNo())))