topic Re: Missing week end dates in QlikView

Missing week end dates

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I amusnig the below expression to get the running total please let me know if this iscorrect .

=if(IsNull(Category),
RangeSum(Above(TOTAL Count(RaisedDate),0,RowNo(TOTAL))),
RangeSum(Above(TOTAL Count({<Dept=P(Category)>}RaisedDate),0,RowNo(TOTAL))))

After this i see that some of the dates of the line chart missing with data , how can i achive this .

as shown in the screenshot below From 2/29/2020ks it is directly showing 3/21/2020 Can you please guide me on do I make this correct

Re: Missing week end dates

smilingjohn — Tue, 07 Jul 2020 11:42:37 GMT

Hi Community any help on this

Re: Missing week end dates

Kushal_Chawda — Tue, 07 Jul 2020 11:52:52 GMT

would you be able to share sample with expected output?

Re: Missing week end dates

smilingjohn — Tue, 07 Jul 2020 14:01:16 GMT

Thanks @Kushal_Chawda

I want to have the runing total for line chart and i see that thrre are nissing weekends . it should not be missing if there is no records it should carry on previous week data . this should be cummulative

and i am using the above mentioned expression

Thanks in Advance.

Re: Missing week end dates

Kushal_Chawda — Tue, 07 Jul 2020 14:55:08 GMT

do you want running total on Count(RaisedDate)? What is the dimension? Sorry I can't check qvw file

Re: Missing week end dates

smilingjohn — Wed, 08 Jul 2020 03:15:31 GMT

Sorry I forgot to attach.
Now i have attached , I am trying to get the running total , but there are some weekend missing it.
Please do suggest me how to bring up the missing weekends.

Re: Missing week end dates

Kushal_Chawda — Tue, 07 Jul 2020 18:42:26 GMT

do you want running total on Count(RaisedDate)? What is the dimension? Sorry I can't check qvw file

Re: Missing week end dates

smilingjohn — Wed, 08 Jul 2020 03:18:26 GMT

Hi @Kushal_Chawda

I want to show running total on 3 dates "RaisedDate", "DeliveredDate" and "ClosedDate" and the dimension is Weekend(RaisedDate).

Thanks