Where id is an identification number, yr is year, course is a course code, ind1 and ind2 are [0,1]-indicators indicating which course was completed for level 1 and 2, and prov is the course provider.
The output i want is a table with id in rows, yr in colomns, where the cells are populated with the course code completed.
I use a pivot table/chart. In the attached picture there two tables, where I for simplicity have yr as rows instead of colomns. There you also can see the expressions I have written. In the first table the correct course provider and course code is listed. Then i want to use the course dimension as expression. In the second table I have tried to solve this, but course code a is not listed.
By reading posts in the Qlik-community, it seems like this can be solved by aggr. I have used aggr in several other expressions, but I have not been able to figure it out this time.