Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Any solution ?
Hi Expertise waiting for your help on my post ...
Thanks
Stuck with this assignment .Seeking help
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