Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
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))
=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,
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.
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.
You add Create Date as a Dimension
then you create two expressions:
One for all cases that have been created:
and one for the cases that have been closed:
you should get the results you are looking for as per the example of the graph
Thank you for the solution. I got the output that I expected.
Thank you for the reply. I got the solution from Stefan.