3 Replies Latest reply: Nov 8, 2013 5:49 AM by Vannick TRINQUIER

# 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

• ###### Re: Chart with difference between week N and week N - 1

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.

• ###### Re: Chart with difference between week N and week N - 1

Dear ,

Kindly find the attachment.

Thanks,

Mukram.

• ###### Re: Chart with difference between week N and week N - 1

Hi,

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

Have a good day or night

Thanks