Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ozymandias
Contributor
Contributor

Joining multiple tables to visualize

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?

0 Replies