Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Create Chart Dimension from Two Fields Value.

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

1 Solution

Accepted Solutions
MVP
MVP

Create Chart Dimension from Two Fields Value.

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

7 Replies
Not applicable

Create Chart Dimension from Two Fields Value.

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.

Not applicable

Create Chart Dimension from Two Fields Value.

Hi

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.

Graph.JPG

Not applicable

Re: Create Chart Dimension from Two Fields Value.

Hi

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.

Graph.JPG

MVP
MVP

Create Chart Dimension from Two Fields Value.

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

Not applicable

Create Chart Dimension from Two Fields Value.

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

Not applicable

Re: Create Chart Dimension from Two Fields Value.

Dear Stefan

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

Regards

Abu

Not applicable

Re: Create Chart Dimension from Two Fields Value.

Hi Paul

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

Regards

Mohamed Abubakker

Community Browser