topic Re: Remove Null Line in Line Chart in QlikView

Remove Null Line in Line Chart

hamdaniahmad — Mon, 02 Apr 2018 11:36:40 GMT

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.

Re: Remove Null Line in Line Chart

sunny_talwar — Mon, 02 Apr 2018 11:39:32 GMT

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

Re: Remove Null Line in Line Chart

hamdaniahmad — Mon, 02 Apr 2018 11:51:55 GMT

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)

Re: Remove Null Line in Line Chart

sunny_talwar — Mon, 02 Apr 2018 11:56:29 GMT

And is this doing full accumulation?

Re: Remove Null Line in Line Chart

hamdaniahmad — Mon, 02 Apr 2018 12:06:49 GMT

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.

Re: Remove Null Line in Line Chart

sunny_talwar — Mon, 02 Apr 2018 12:12:55 GMT

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()))

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())))