Carry data along with date

[smilingjohn]

Hi All,

I have to create a line chart of my count of  ID's by weekstart. 

Now my requirement is like :

I need to show all the tickets which were opened in past till current weekstart date for example :

ID-1	low	Nov/22/2019
ID-2	Medium	Feb/9/2020
ID-3	Medium	Feb/9/2020

If you look in the above table I have ID-1 for Low  on  date 22nd-Nov-2019

when i covert the date to weekstart  (I have Master Calendar) then the Dimension would be Weekstart and expression is count(ID) by doing this when the line chart shows only the dot for Feb-09-2019 . 

What i want is to show is that , the count of (ID)which is one (on Feb-09-2019 )  should keep showing 1 count  till current weekstart which is 17th Feb-2020. ( if theer is no data for any of the weekstart then the line chart should show the previous data . 

How do i achive this ? can someone please hep me on this 

thanks in dvance 

[smilingjohn]

Any solution ? 

[smilingjohn]

Hi Expertise waiting for your help on my post ...

Thanks 

[smilingjohn]

Stuck with this assignment .Seeking help 

[Brett_Bleess · Accepted solution]

This one likely needs an example QVW with data model etc., so folks can better see what is going on behind the scenes to try to figure out the best way to handle things...

The best I can do for you otherwise is to guide you to the Design Blog area to search for posts there to see if you can find some things that will help you with the use case.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett