Your question is very generic, so I’m not sure how to address. Qlik has a bunch of how to videos and basic trainings I would recommend looking up to get started. I’ve listed some general steps below to give you an idea of what you may need to read/watch videos on as a start. Then when you run into issues, you’ll have a more specific issue that can be asked and addressed.
Do you have a connection to your database established?
Once you have this you can either directly query your database for this app or query the database on a schedule (say once daily) and save off that data and any other database tables you would want to reference in apps into Qlik files (qvd) to be referenced in your apps as the data sources. The latter is what I’ve seen done most often to minimize many hits on the system due to queries.
Once you have your data loaded in, it depends on its format, but it looks like a pivot table would serve as the chart to present the data in your required format.
