Creating a pivot table

nkosinde13 — Wed, 25 Nov 2020 16:16:04 GMT

I'm new to Qlikview and loading data is one of my biggest challenges.

I have data of employees with the courses they have enrolled in as well as the expiry date of each courses. I need to create a view where I show for each employee, outstanding courses, expiry date for the outstanding courses, as well number of completed courses.

I can get number of completed courses for each employee (refer to table named: Completion) but I'm struggling to get the full view on one table. The example of the view I need to create is Text Object next to the Completion table. Is this even possible? Or do I need to change the way I load my data? Please help

Regards

Matlotlo Modisane

Re: Creating a pivot table

sunny_talwar — Tue, 05 Jun 2018 12:04:10 GMT

Are you able to share TrainingDetails.xlsx file? I think doing The Crosstable Load will make this very easy.

Re: Creating a pivot table

nkosinde13 — Mon, 11 Jun 2018 14:01:59 GMT

Thank you Sunny, I was able to create a cross table which solved my problem 🙂

topic Re: Creating a pivot table in QlikView

Creating a pivot table

Re: Creating a pivot table

Re: Creating a pivot table