Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a trend chart (Line chart) of my tickets by weekstart .
Here i am showing the total tickets every week (Every week start) in a cummulative way .
Say for example I have weekstart like : 16_feb-2020 ,23-Feb-2020, 01-Mar-2020 ,08-Mar-2020.
Now the trend chart behaviour is (Cummulative) if there are 2 tickets opened on 16-Feb-2020 then the line will show 2 tickets even at 16-Feb-2020 ,23-Feb-2020 if there are 5 tickets
opened on 01-Mar-2020 and the trend chart should show 5 tickets even on 08-Mar-2020. But this is adding up all the previous tickets also and shows the result as 7 tickets on 08-Mar-2020
.
I have used below formula :
if(count({<SEVERITY={'1 - Critical'}>}Ticket)+ Sum({1<Year=P(Year),Month=p(Month)>}0)=0,
rangeSum(above(TOTAL count({<SEVERITY={'1 - Critical'}>}Ticket)+ Sum({1<Year=P(Year),Month=p(Month)>}0),0,RowNo(TOTAL))),
count({<SEVERITY={'1 - Critical'}>}Ticket)+ Sum({1<Year=P(Year),Month=p(Month)>}0))
Can you please suggest me on this ? how do i show the trend (Cummulative ) from the tickets on the week it opened and it should continue the same rather than adding previous tickets .
Thanks in Advance
Any Help on This ?
Hi Expertise any update on this please ?
Hi Maybe provide some sample data and expected result may help to answer the question. Thanks!
Alex thanks for the reply
This is how i want to the output . If you look on 2nd-Feb-2020 there were two tickets therefore the same ticket is shown till 16th-Feb-2020 ( As there were no tickets on 9th and 16th Feb-2020) and there was one ticket opened on 23rd-Feb-2020 which was shown till 1-mar-2020 and so
Week Start Tickets
2-Feb-2020 2
9-Feb-2020 2
16-Feb-2020 2
23-Feb-2020 1
1-Mar-2020 1
8-Mar-2020 4
15-Mar-2020 1
Thanks
Along Alex's prior post, if you really want help on this one, I would recommend you post your QVW file so folks can see what they need to see in order to help, which is going to be the data model, chart objects and the associated expressions along with the chart settings.
The only other place I can point you otherwise is the Design Blog area to see if you can find something there that may put you on the right track with things.
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
If the QVW has sensitive data, you can use the Desktop Client and the Settings\Document Properties\Scrambling tab to scramble those fields that you do not want anyone to be able to really read the values.
Regards,
Brett