topic Re: Creating a sheet in Qlikview 11 from multiple QV files in QlikView

Creating a sheet in Qlikview 11 from multiple QV files

Mon, 23 Nov 2015 17:18:38 GMT

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!

Re: Creating a sheet in Qlikview 11 from multiple QV files

maxgro — Mon, 23 Nov 2015 18:06:34 GMT

do you mean .qvd files? or .qvw?

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

Re: Creating a sheet in Qlikview 11 from multiple QV files

Mon, 23 Nov 2015 18:39:18 GMT

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.

Re: Creating a sheet in Qlikview 11 from multiple QV files

maxgro — Mon, 23 Nov 2015 18:49:25 GMT

I think you should use one .qvw

Anyway, post the .qvw.

Re: Creating a sheet in Qlikview 11 from multiple QV files

Mon, 23 Nov 2015 19:07:20 GMT

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

Re: Creating a sheet in Qlikview 11 from multiple QV files

maxgro — Mon, 23 Nov 2015 19:40:39 GMT

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).

Re: Creating a sheet in Qlikview 11 from multiple QV files

Mon, 23 Nov 2015 19:46:34 GMT

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.

Re: Creating a sheet in Qlikview 11 from multiple QV files

maxgro — Mon, 23 Nov 2015 20:39:06 GMT

These are the script of your 3 .qvw

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;

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;

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;