Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Cummulative  Trend

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

5 Replies
smilingjohn
Specialist
Specialist
Author

Any Help on This ?

smilingjohn
Specialist
Specialist
Author

Hi Expertise any update on this please ?

alex00321
Creator II
Creator II

Hi Maybe provide some sample data and expected result may help to answer the question. Thanks!

smilingjohn
Specialist
Specialist
Author

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 

Brett_Bleess
Employee
Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.