Data model question

[#1]

I have trouble ticket data, with one row per ticket (issue).  Each row has a status (open or closed), a created_week (Saturday of the week the ticket was opened), and a resolved_week (Saturday of the week the ticket has been closed, if it was closed; else NA). 

I’d like a bar chart with a bar per week, showing the opened count (count of rows with the matching creation week) minus the closed count (count of rows with resolved week equal to bar label).  In other words, the net change to the cumulative number of open tickets each week.  Can I do this with the data structure I have?  Or do I need a different data model? 

I'm using Qlik Sense.

[rubenmarin]

Hi Gerard, your base trouble is counting one record in two different dates? Maybe this post can help you: Canonical Date

[jolivares]

Check this sample QVW, it help a lot for build muy own.

http://us-b.demo.qlik.com/detail.aspx?appName=Help%20Desk%20Management.qvw

[reddy-s]

Hi Gerard,

You should be able to achieve what you are looking for. If you face any issues, attach a sample QVF file.

Thanks,

Sangram.