Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
caffeweb
Contributor II
Contributor II

Link Table

Hello all, 

This is my first time to use Qlik, if I resolve my problem I god the JOB 😄
Because of that I need your help. I can`t link my another sheet and got information from first sheet.

Question is:

For the Exam Table (BI, Subject, Rating), do the following:

1. Create students data in the Excel table, load these data into QlikView and display results in the table and in graphics.

2. Make a tabular presentation of the best students.

3. Create an additional Student table
(BI, Name, Surname, Address, City) in a new sheet in the same Excel file

4. Introduce this table in QlikView and create an additional table showing where the best students are in town and compare cities by success.

5. Make some additional analysis that you think would be interesting, as well as additional charts.

6. Make JOIN in the load script.

13 Replies
caffeweb
Contributor II
Contributor II
Author

When i select Fields Town, for example: Town Sombor is best town, not Arandjelovac. 
Bi number 2 is best student, and I got this information.
But Arandjelovac is on first place on Box, how to calculate Rating to show me which is Town better?

1212.PNG

pradosh_thakur
Master II
Master II

No No.. That town is just a list box . It doesn't tell you which one is better , create the same chart, but instead of id put town in the dimension. You will get the correct output. Let me know. You have to understand the object first.

Learning never stops.
caffeweb
Contributor II
Contributor II
Author

HEEEEEY I HOPE THAT I FIND A WAY 😄

Em I right?

Graficki prikaz final.PNGTabelarni prikaz FINAL.PNG

pradosh_thakur
Master II
Master II

Yes you are right if the criteria for best town is to have the highest rating .

Learning never stops.