Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
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
smilingjohn
Creator III
Creator III

Hi Community any help on this 

Kush
MVP
MVP

would you be able to share sample with expected output?

smilingjohn
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.

Kush
MVP
MVP

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

smilingjohn
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.

 

Kush
MVP
MVP

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

smilingjohn
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