topic Re: Carry data along with date in QlikView

Carry data along with date

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

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

Re: Carry data along with date

smilingjohn — Fri, 21 Feb 2020 03:56:38 GMT

Any solution ?

Re: Carry data along with date

smilingjohn — Fri, 21 Feb 2020 16:46:59 GMT

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

Thanks

Re: Carry data along with date

smilingjohn — Mon, 24 Feb 2020 12:20:10 GMT

Stuck with this assignment .Seeking help

Re: Carry data along with date

Brett_Bleess — Wed, 25 Mar 2020 20:00:28 GMT

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