Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nkosinde13
Creator
Creator

Creating a pivot table

Hi

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

2 Replies
sunny_talwar

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

nkosinde13
Creator
Creator
Author

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