Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Missing week end dates

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 

 

smilingjohn_1-1594116644109.png

 

 

7 Replies
Creator III
Creator III

Hi Community any help on this 

MVP
MVP

would you be able to share sample with expected output?

Creator III
Creator III

Thanks @Kush 

 

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.

MVP
MVP

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

Creator III
Creator III

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.

 

MVP
MVP

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

Creator III
Creator III

Hi @Kush  

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

 

Thanks