Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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

View solution in original post

7 Replies
Not applicable
Author

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
Author

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
Author

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

swuehl
MVP
MVP

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
Author

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
Author

Dear Stefan

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

Regards

Abu

Not applicable
Author

Hi Paul

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

Regards

Mohamed Abubakker