Should I use Set analysis or ... ?

waszcma1 — Mon, 08 Sep 2014 09:21:16 GMT

Could anyone help me with this?

I have row data ~ 500 000 transactions (opened in 2014)

I want to display the number of not closed cases at the particular month/week (backlog)

How can I do graph/pivot on the scale month/week?

I tried this but it works only if I use it only as a snap shot

But if I use dimensions: month(inc_opened_at)

and expression #1 :

count({< inc_opened_at = {"< $(=max(inc_opened_at))"}, inc_closed_at = {"> $(=max(inc_opened_at))"} >}inc_number )

it shows 0 for all months

I know I am doing something wrong but could you help me to find solution to find the right direction?

When I use only dimensions: month(inc_opened_at)

and expression #2:

max(inc_opened_at)

Month expression #1 expression #2

Jan 0 31/01/2014

Feb 0 28/02/2014

Mar 0 31/03/2014

Apr 0 30/04/2014

May 0 31/05/2014

Jun 0 30/06/2014

Jul 0 31/07/2014

Aug 0 31/08/2014

topic Should I use Set analysis or ... ? in QlikView