I have multiple tables already loaded into Qlik sense using the data manager. I want to show a number, which has multiple units under it, which each have dates associated with them. For example, let's say I have student ids, which each have multiple course numbers under them. Each course has a start and finish date. I think I should use a pivot table to visualize this, because it allows me to expand the student ids into the different course numbers, but I don't know which measure, if any, to use. I'm not aggregating anything.
I thought using a crosstable would help here, but in order to do that I have to join a bunch of tables in the script editor to create a new table which I can then use the crosstable on. I had it time out on me. Any help would be appreciated.
One last question. If I've already loaded all these tables, and I don't use fields from every table--they're just there to provide associations so the fields I need connect to each other--do I have to join these tables when I'm creating my big crosstable in the script editor?
