Creating a sheet in Qlikview 11 from multiple QV files

[#1]

Hello all, i am new to Qlikview and i have some trouble making a sheet from multiple QV files. Can someone please help me? Thanks!

[maxgro]

do you mean .qvd files? or .qvw?

could you explain and/or post your .qvw and what do you want to achieve

[#3]

I have three .qvw files which i need to merge into one using sheets. Its a simple table report showing best students by counting average score, and one is showing best students by city. Third one is only showing students which have successfully passed the Programming exam. Do you want me to attach the files if it helps? Thanks.

[maxgro]

I think you should use one .qvw

Anyway, post the .qvw.

[#5]

Here are the three .qvw files i need to merge into one using sheet.

[maxgro]

These are charts. not .qvw.

If your .qvw are small you can use advanced editor (top right) and then attach (bottom right) to attach your .qvw.

Just to start

In Qlik usually you build a Qlik database loading data from external source and then you use that database to build many charts.

1 .qvw, 1 database, many charts.

It seems from your 1st and 3rd charts you can try  to merge the data from the 1st and 3rd .qvw in one .qvw as they have the same fields. Start here or post the .qvw (I hope your .qvw are small).

[#7]

Ok, i have attached the three as you instructed. By the way, my tables are created via access and i have imported them to QV via ODBC and there i have done some basic calculations like avg on score.

[maxgro]

These are the script of your 3 .qvw

2

LOAD *;

SQL SELECT Student.GradID AS GradID, Grad.Naziv, Avg(Ispit.Ocena) AS [ProsekGrada]

FROM (Student INNER JOIN Ispit ON Student.[BI] = Ispit.[BI]) INNER JOIN Grad ON Student.[GradID] = Grad.[ID]

GROUP BY Student.GradID, Grad.Naziv

ORDER BY Avg(Ispit.Ocena) DESC;

1

LOAD BI, Ime, Prezime, Avg(Ocena) as prosek group by BI,Ime,Prezime;

SQL SELECT Student.BI, Student.Ime, Student.Prezime, Ispit.Ocena

FROM Student ,Ispit

WHERE Student.BI=Ispit.BI;

Pr

LOAD *;

SELECT Student.BI, Student.Ime, Student.Prezime, Ispit.Ocena, Predmet.Naziv

FROM Student INNER JOIN (Predmet INNER JOIN Ispit ON Predmet.ID=Ispit.[PredmetID]) ON Student.[BI] = Ispit.[BI]

WHERE Predmet.Naziv = 'Programiranje'  AND Ispit.Ocena > 5;

These the 4 tables of your 3 .qvw

Student      BI, Ime, Prezime, GradID

Ispit            BI, Ocena, PredmetID

Grad           ID as GradID, Naziv as GradNaziv

Predmet    ID as PredmetID, Naziv as PredmetNaziv

I would start with one .qvw, all the tables with this script

ODBC CONNECT TO [MS Access Database;DBQ=C:\Users\Anci\Desktop\QVaccess.accdb];

Student:

LOAD *;

SELECT BI, Ime, Prezime, GradID from Student;

Grad:

Load ID as GradID, Naziv as GradNaziv;

SELECT ID, Naziv FROM Grad; 

Ispit:

Load *;

SELECT BI, Ocena, PredmetID from Ispit;

Predmet:

Load ID as PredmetID, Naziv as PredmetNaziv;

SELECT ID, Naziv FROM Predmet;