topic Create a new table from 3 others in QlikView

Create a new table from 3 others

Sun, 24 Apr 2011 01:18:36 GMT

Hi,

I need some help, as subject says, in how to create a new table from the relation of 3 other tables.

Example: I have three tables, "StudentId", "Subject Name" and "Grade". And I want to create a new one with all students grade for a specific subject. It means.. instead of show Student ID's, this new table will show all student grades of, for example, Math subject.

Thanks in advance

Create a new table from 3 others

deepakk — Sun, 24 Apr 2011 07:47:40 GMT

hi,

You can use join function, to get all three tables into one.

eg:

Load StudentID, Name, SubjectID,GradeID from Table1;

join

load SubjectID, SubjectName from table2;

join

Load GradeID, GradeName from table3;

Create a new table from 3 others

Sun, 24 Apr 2011 13:18:28 GMT

Can I use that join function on table (the new one) properties as an expression?

Create a new table from 3 others

deepakk — Sun, 24 Apr 2011 13:41:38 GMT

hi,

You have to do it an script level. not on front end.

Create a new table from 3 others

deepakk — Sun, 24 Apr 2011 13:43:27 GMT

hi,

If you want three tables data to be in one in front end then just link the three tables.

You have to make sure the field names are same to link it. The add the fields in Pivot or Straight or normal table.

Create a new table from 3 others

Sun, 24 Apr 2011 13:54:46 GMT

Ok, i'll try.

Thanks a lot 😉