Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator III
Creator III

Hi Community any help on this 

Highlighted
MVP
MVP

would you be able to share sample with expected output?

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

Highlighted
MVP
MVP

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

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

 

Highlighted
MVP
MVP

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

Highlighted
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