topic Re: How to avoid null values in Qliksense Cumulative Line Chart in App Development

How to avoid null values in Qliksense Cumulative Line Chart

SatyaPaleti — Sat, 16 Nov 2024 17:52:12 GMT

Hi Folks,

Can some one please help to fix this Issue. I am using a line chart and we want to show Monthly Count of Customers in Cumulative

So I have taken Month & Product as Dimensions and Expression is Count (Customers). I am getting below chart

If we look at June -17 one of the product (red colour) is laying down due to null value but it should not happen. The value should be repeat as 239.

Is there any way to sort out this Issue. I have used below formula but I'am not getting result as expected

Aggr(RangeSum(Above(Count(Cust.No), 0, RowNo())), (Product), (Prod.Date, (NUMERIC, ASCENDING)))

Can some one please help me on this

Thanks and Regards,

Satya

Re: How to avoid null values in Qliksense Cumulative Line Chart

Anil_Babu_Samineni — Thu, 05 Nov 2020 17:17:02 GMT

For me, IT doesn't make sense If you want to use same. But you can try something like below in case IF you need forcibly

If(Count (Customers)=0, Above(Count (Customers)), Count (Customers))

If(IsNull(Count (Customers), Above(Count (Customers)), Count (Customers))

Re: How to avoid null values in Qliksense Cumulative Line Chart

SatyaPaleti — Sat, 07 Nov 2020 03:06:31 GMT

Hi Anil,

Thank you so much for your response on this. For Example I have a Product and count of Production is Increasing Day by Day and My Production starts in Jan 2019 and User want to see the growth of Production since Jan 2019 to November 2020. In the Month of August 2020 Production is not happened and we were doing Accumulation even though there is No values It have to show previous Month data. if July has Production Value 238 then August should also show 238 even if there is No August Value Because it's an Accumulation. If you convert line chart in to Table then it will show the same values but in Line chart Values were Missing. So This is the Issue here. Did It Make Sense Now??

Re: How to avoid null values in Qliksense Cumulative Line Chart

Amal — Mon, 24 Jan 2022 10:31:14 GMT

hi @Anil_Babu_Samineni and @SatyaPaleti , I am having the same issue. How did you manage to resolve it ? Although, in my case, even though I convert to a table, it doesn't show up.

thanks in advance.

Re: How to avoid null values in Qliksense Cumulative Line Chart

chris_djih — Mon, 24 Jan 2022 12:09:46 GMT

My short suggestion is better handling of null-values in the script (data modell).
the red line on June-17 os not realy a null value but a zero value -> there was 0 products added.
null would mean: i don't know nothing about June-17.
Try to set the value for June-17 on the red product to zero instead of null in the script.
The chart should work after data is fixed.