topic Re: Link Table in QlikView

Link Table

caffeweb — Mon, 25 Mar 2019 11:55:22 GMT

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.

Re: Link Table

pradosh_thakur — Mon, 25 Mar 2019 12:04:47 GMT

Hi @caffeweb ,

There are many in the community who can easily answer your questions and give you a data model and UI. If you ask me it's not going to help you in long term and in the JOB as well. If this is your first time using Qlik i would encourage you to take a month or two , learn the basics , use the qlik continuous classroom , community then go for a new job with Qlik. Rest is up to you. Good luck.

-Pradosh

Re: Link Table

caffeweb — Mon, 25 Mar 2019 12:11:04 GMT

First of all, thanks to the answer, the thing is they know that I have never used Qlik, and it's about seeing how much and how I'll manage. They know that I do not know much (in the meantime, I have learned a lot), and they gave me 2 weeks to solve this task and convince them that I was working. I was trying to find the scripts I found (I imported a second sheet) but I can not get the correct information.

Re: Link Table

pradosh_thakur — Mon, 25 Mar 2019 12:17:15 GMT

Allright, Load both the sheet in qlikview They will be associated using the field BI. Do that and show us your data model. Let's do this step by step.

Re: Link Table

caffeweb — Mon, 25 Mar 2019 12:24:09 GMT

I am very grateful to you, much to me will mean to you or to anyone whose help I am making more and more.

Re: Link Table

caffeweb — Wed, 27 Mar 2019 09:47:01 GMT

Hello all,

Does anyone have information how to help me about that.
Man who told me that help me no answer, I need to search another oppinion.

Thank you all

Re: Link Table

pradosh_thakur — Wed, 27 Mar 2019 10:00:41 GMT

Hi @caffeweb

I want you to know that answering in the community is not the only thing we do, we have our jobs as well . I want you to understand that.

I have mentioned earlier answering everything will not help you. I have asked you to show me how your data model looks which you haven't yet. You need to put effort to get answers and just not expect someone to answer it on behalf of you.

Please post a screenshot of your data model for me to help you else i will not be able to help and i hope someone else will.

-Pradosh

Re: Link Table

caffeweb — Wed, 27 Mar 2019 10:36:29 GMT

I understand you, I mean maybe you don`t have time and wait you to give me skype name for better communication.

I take screenshot:

I need to connect Bi from Ispiti to Town on field Studenti...

Re: Link Table

pradosh_thakur — Wed, 27 Mar 2019 10:44:19 GMT

Your script is good and the fields are associated. You don't need to join the field town. Use the field with the expressions and it shall work perfect.

Re: Link Table

pradosh_thakur — Wed, 27 Mar 2019 10:49:29 GMT

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

You have done the above.Add some charts to show it in graphical form

2. Make a tabular presentation of the best students.

Use student and sum(ratings) in a table, limit it in the dimension limits tab .

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

You have don the above.

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

Use Town , student, sum(ratings) in 1 table

Use Town and some expression to show the best performing city

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

Add some comparative analysis, show the percentage share in pie, trends in bar etc, Use chart as per requirement.

6. Make JOIN in the load script.

You don't need to join the table, if you want to may be do a left/inner join

-Pradosh

Re: Link Table

caffeweb — Wed, 27 Mar 2019 10:53:59 GMT

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?

Re: Link Table

pradosh_thakur — Wed, 27 Mar 2019 10:59:26 GMT

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.

Re: Link Table

caffeweb — Wed, 27 Mar 2019 13:27:32 GMT

HEEEEEY I HOPE THAT I FIND A WAY 😄

Em I right?

Re: Link Table

pradosh_thakur — Wed, 27 Mar 2019 15:09:02 GMT

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