topic Re: Set analysis... or something else? in QlikView

Set analysis... or something else?

clausbarlose — Tue, 27 Jan 2015 19:21:34 GMT

I am bugged by the question of how to do this the easiest way, and I ask the community for help.

The data record is very simple:

Tickets:

TicketID (Key)	I-154356
Created	2014-12-31
Title	Thrusters defect

Dataset consists of a number of rows with ticket details, each with a different creation date.

Current selection is e.g. December 2014 and I want to show number of tickets created rolling month, twelve months back in time in a graph with year/month as the dimension.

Will it be necessary to create another table to do it or can it be done with set analysis?

Kind regards

Claus

Re: Set analysis... or something else?

maxgro — Tue, 27 Jan 2015 19:46:21 GMT

try with

dimension =Year(Created) & '-' & num(Month(Created),'00')

expression =count({$ <Created={">=$(=monthstart(addmonths(today(),-12)))<=$(=today())"}>} TicketID)

set full accumulation for expression and set the sort order

Re: Set analysis... or something else?

clausbarlose — Tue, 27 Jan 2015 20:37:18 GMT

Thanks, Massimo. Forgot to tell though, that twelve months rolling is not calculated from today() but Created.

I will have to try your formula out before I can tell if it works.

Thank you!

Kind regards,

Claus