Link Table

[caffeweb]

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.

[caffeweb]

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?

[pradosh_thakur · Accepted solution]

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.

[caffeweb]

HEEEEEY I HOPE THAT I FIND A WAY 😄

Em I right?

[pradosh_thakur]

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