topic Set Analysis Graph with two dimensions in QlikView

Set Analysis Graph with two dimensions

Thu, 30 Jan 2014 16:02:06 GMT

Hi;

I have two different graph:

Graphic 1

- dimension: MonthYear1 //((from table closedd cases time)

- expression: =sum({BM11<Condition={'CLOSED'},CLOSE_DATE={">$(=max(AddMonths(vLastMonth1, -5)))<$(=max(AddMonths(vLastMonth1, +1)))"}> }CaseCounter)

Graphic 2

- dimension: MonthYear2 //(from table created cases time)

- expression: =sum({BM11<MonthYear2={">$(=max(addmonths(vHoy, -7)))<=$(=max(addmonths(vHoy, -1)))"}> }CaseCounter)

Now, how I can make an only one graphic to integrate this?

Re: Set Analysis Graph with two dimensions

MK_QSL — Thu, 30 Jan 2014 22:38:42 GMT

Can you upload a sample file?

Re: Set Analysis Graph with two dimensions

Thu, 30 Jan 2014 22:51:59 GMT

hey Mario,

You can try adding two dimensions and both the expressions in a bar chart. But without knowing how they look or what kinda resultant graph you are looking for its tough to answer. As stated by @Manish please attach a sample doc.

Re: Re: Set Analysis Graph with two dimensions

Fri, 31 Jan 2014 16:22:38 GMT

Here the example...

Thanks

Re: Re: Set Analysis Graph with two dimensions

Fri, 31 Jan 2014 16:26:41 GMT

Here the example... Thanks

Re: Set Analysis Graph with two dimensions

Fri, 31 Jan 2014 17:07:33 GMT

Mario,

The way I would do it, create a separate resident table from 'Cases' like

TempTable:

PKY,

Create_Date as Date,

'Open' as Condition

Resident Cases;

Concatenate

PKY,

Close_Date as Date,

'Closed' as Condition

Resident Cases;

Drop field Condition from Cases;

Make sure PKY is a unique field in Cases table. You can use rowno(). Then use this 'Date' field in the dimension and the two expressions you already have in the same chart and you can include Condition in the Set to determine which is opened/Closed.

Hope it helps

Thanks

Re: Set Analysis Graph with two dimensions

santharubban — Fri, 31 Jan 2014 17:14:05 GMT

you can added one more expression in the chart and place second expression.

Re: Set Analysis Graph with two dimensions

Fri, 31 Jan 2014 18:25:19 GMT

Thanks "Ajay Prabhakaran"...

I can't solve this...

Sorry I'm new in QlikView and not understand many things...

Re: Set Analysis Graph with two dimensions

Fri, 31 Jan 2014 18:38:53 GMT

Sorry santharubban, but how I can remove Mar 2013, Apr 2013, May 2013, Jun 2013 from the graphic?

Re: Set Analysis Graph with two dimensions

Fri, 31 Jan 2014 18:54:21 GMT

santharubban, with your solutions, the totals don't mach, you can see this?