Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
lukegilligan
New Contributor III

Replicating Jira graph in Qlikview - Open/Closed tickets per day

I am trying to replicate the following graph that is on our Jira service desk in Qlikview:

jira graph.PNG

 

I have been able to get the data in to QV with no issues, but I am having a problem counting the number of resolved issues per day due to the fact that I am using the Created Date as the dimension, which is an issue due to the fact that there are tickets that are resolved on dates where new tickets weren't created.

I presume I will need to use some sort of master calendar to get this working, but am getting a bit stuck how to generate the extra dates to allow the resolved dates to show.

Attached is a QVD of where I have got to so far.

Any help would be much appreciated.

Luke

1 Solution

Accepted Solutions
Claudiu_Anghelescu
Contributor III

Re: Replicating Jira graph in Qlikview - Open/Closed tickets per day

You need a common Dimension for Creation.Date and Resolved.Date.

 


JiraDataCreated:
LOAD 
......
FROM ....;

 

NoConcatenate
Table:
LOAD *,
'C' as Flag,
Created.Date as Date
Resident JiraDataCreated
WHERE Created.Date <> '';

Concatenate


LOAD *,
'R' as Flag,
Resolved.Date as Date
Resident JiraDataCreated
WHERE Resolved.Date <> '';


Drop Table JiraDataCreated;

To help community find solutions, please don't forget to mark as correct.
3 Replies
Claudiu_Anghelescu
Contributor III

Re: Replicating Jira graph in Qlikview - Open/Closed tickets per day

You need a common Dimension for Creation.Date and Resolved.Date.

 


JiraDataCreated:
LOAD 
......
FROM ....;

 

NoConcatenate
Table:
LOAD *,
'C' as Flag,
Created.Date as Date
Resident JiraDataCreated
WHERE Created.Date <> '';

Concatenate


LOAD *,
'R' as Flag,
Resolved.Date as Date
Resident JiraDataCreated
WHERE Resolved.Date <> '';


Drop Table JiraDataCreated;

To help community find solutions, please don't forget to mark as correct.
Support
Support

Re: Replicating Jira graph in Qlikview - Open/Closed tickets per day

Here is link to a Design Blog post regarding Master Calendar, there are some other Calendar posts out there as well, just FYI, hopefully this may help further.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
lukegilligan
New Contributor III

Re: Replicating Jira graph in Qlikview - Open/Closed tickets per dayThan ks

Thanks this is exactly what I was trying to achieve.