topic Create Chart Dimension from Two Fields Value. in QlikView

Create Chart Dimension from Two Fields Value.

Sun, 27 Nov 2011 07:53:02 GMT

Hi All,

I have to build a chart with open issues and closed issues for a range of period. Graph dimensions are,

X-Asis(Bottom) -> Period

Y-Axis -> Issue Count

In Issue Record, I have Create Date and Closed date as two different period.

I don't know how to combine Create Date and Closed Date for X Dimention.

Your Immediate Response is highly appreciated.

Regards

Abubakker

Create Chart Dimension from Two Fields Value.

Sun, 27 Nov 2011 08:23:51 GMT

You can make a Bar chart by compaining Createdate and closed date. In Chart properties under style tab you can set Group or Stacked what ever you want.

Create Chart Dimension from Two Fields Value.

Sun, 27 Nov 2011 08:48:07 GMT

Thanks for quick reply.

But I couldn't get the expected result. Please see the graph below. I need to combine create and closed date into one dimension.

Re: Create Chart Dimension from Two Fields Value.

Sun, 27 Nov 2011 08:48:44 GMT

Thanks for quick reply.

But I couldn't get the expected result. Please see the graph below. I need to combine create and closed date into one dimension.

Create Chart Dimension from Two Fields Value.

swuehl — Sun, 27 Nov 2011 12:19:50 GMT

You could use an additional data island for period (x-Axis) to draw against and your expressions then look like

=count( if(Period=[Closed Date], Issue))

resp.

=count( if(Period=[Create Date], Issue))

Period should have the same granularity (Date) and format (best is numerical representation of a Date data type) like Closed and Create Date.

Hope this helps,

Stefan

Create Chart Dimension from Two Fields Value.

Sun, 27 Nov 2011 21:25:49 GMT

Hi there

You add Create Date as a Dimension

then you create two expressions:

One for all cases that have been created:

rangesum(above(Sum(Count),0,RowNo()))

and one for the cases that have been closed:

rangesum(above(Sum(if(isnull(CloseDate),0,Count)),0,RowNo()))

you should get the results you are looking for as per the example of the graph

Cheers

Paul

Re: Create Chart Dimension from Two Fields Value.

Tue, 29 Nov 2011 06:50:42 GMT

Dear Stefan

Thank you for the solution. I got the output that I expected.

Regards

Abu

Re: Create Chart Dimension from Two Fields Value.

Tue, 29 Nov 2011 06:54:32 GMT

Hi Paul

Thank you for the reply. I got the solution from Stefan.

Regards

Mohamed Abubakker