Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart with difference between week N and week N - 1

Hi all,

I would like to ask some questions about Qlickview. I am still new into this product and I have just to work with the set analysis.

I have a table that contains all the ticket with:

  • Date
  • Ticket Id
  • State that can be new, open or closed to make it simple

Here is the table:

  • Day 1: Ticket ID 1, OPEN
  • Day 2: Ticket ID 1, OPEN
  • Day 2: Ticket ID 2, OPEN
  • Day 3: Ticket ID 1, OPEN
  • Day 3: Ticket ID 2, OPEN
  • Day 3: Ticket ID 3, OPEN
  • Day 3: Ticket ID 4, OPEN
  • Day 4: Ticket ID 1, OPEN
  • Day 4: Ticket ID 2, OPEN
  • Day 4: Ticket ID 3, OPEN
  • Day 4: Ticket ID 4, OPEN
  • Day 4: Ticket ID 5, OPEN
  • Day 4: Ticket ID 6, OPEN
  • Day 4: Ticket ID 7, OPEN

I am already able to get a chart with the number of ticket opened by day doing a count on all the ticket for a date and filtering on the status. For instance:

  • Day 1: 1 tickets opened
  • Day 2: 2 tickets opened
  • Day 3: 4 tickets opened
  • Day 4: 7 tickets opened

I would like to have a chart that give the evolution of the ticket created by day like:

evolution = count (ticket(day(n))) - count (ticket(day(n-1))))

For instance:

  • Day 1: 0 tickets
  • Day 2: 1 tickets created ( 2 - 1 = 1)
  • Day 3: 2 tickets created (4 - 2 = 2)
  • Day 4: 3 ticket created (7 - 4 = 3)

Is anyone could provide me any information. If I need to use the set analysis to be able to do that or if it possible only with expression ? How can I compare the count of the current with the previous day

I know qlickiew since only few days and I do not find information on that.

Thank you very much for any help

Nalysa

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You could try a chart expression like above(count([Ticket ID])) to retrieve the count of the previous date. But if you make selections you can get incorrect numbers because dates that are not show in the table can't be used in calculations. In that case this document may be useful: Calculating rolling n-period totals, averages or other aggregations

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

You could try a chart expression like above(count([Ticket ID])) to retrieve the count of the previous date. But if you make selections you can get incorrect numbers because dates that are not show in the table can't be used in calculations. In that case this document may be useful: Calculating rolling n-period totals, averages or other aggregations

See attached qvw.


talk is cheap, supply exceeds demand
mdmukramali
Specialist III
Specialist III

Dear ,

Kindly find the attachment.

I hope it will help you.

Thanks,

Mukram.

Not applicable
Author

Hi,

Thanks for your response. I was exactly about what i was looking for.

Have a good day or night

Thanks