topic Average expression shows values not average in QlikView

Average expression shows values not average

Petrolucio — Mon, 26 Jan 2026 21:26:37 GMT

Hello i am new to qlikview.

In SQL all these ideas i have work but here they dont.

I have 2 tables as in picture attached.

I used this as join:

Student:
LOAD BI,
Ime,
Prezime,
Adresa,
Grad,
Pol
FROM
[Zadatak dva.xlsx]
(ooxml, embedded labels, table is Studenti);

left join(Student)

Ispit:
LOAD BI,
PredmetID,
Ocena,
[Godina studija]
FROM
[Zadatak dva.xlsx]
(ooxml, embedded labels, table is [Ispiti 4 godina]);

And as you can see in problem.png attachemnt when i dont enter "Ocena=Score(on english)" the avg count actually works and show unique ID,Name,LastName but as soon as i enter Ocena where i expect to show average from all Marks.

Tried a lot of things but it always fails.

Re: Average expression shows values not average

Or — Wed, 24 Mar 2021 18:32:10 GMT

It's a bit hard to figure out what you're doing, but if I understand it correctly, you expect the Ocena column in your second table to show the average Ocena for the first three dimensions? It looks like it's been added as a dimension, whereas if you want it to be averaged, you need to add it as a measure and use avg(Ocena).

Not sure if that's what you meant or not....

Re: Average expression shows values not average

Petrolucio — Wed, 24 Mar 2021 19:33:40 GMT

Hmm, let me try to explain better. IF you look at problem 2.png, you will see 2 tables in excel.

I want to create a table box in qlickview, that will show "BI,Ime,Prezime" from "table1" and "Ocena" as average measure from "table 2".

Connection between 2 tables is "BI"

If i put BI,Ime,Prezime in table box as fields displayed and sort "BI" as expression AVG(Ocena) it will show the table that you see on problem.png as left table.

But as soon as i also add "Ocena" as field displayed even if there is AVG(Ocena) as expression on "BI" it will show as table on the right in problem.png

Hopefully i was able to explain better now.

Re: Average expression shows values not average

Or — Wed, 24 Mar 2021 20:19:07 GMT

Sorry, but I still don't follow. Why are you using a table box rather than a straight table? Why are you adding Ocena as a dimension instead of just using an Avg(Ocena) measure?

Re: Average expression shows values not average

Petrolucio — Wed, 24 Mar 2021 20:28:40 GMT

Thanks a lot man i am new to qlickview, sorry and i broke my head so long when the answer was simple... I created all tables as table box instead of straight table oh god im so stupid and i tried all possible joins and i still couldn't do what i wanted ahahahaha

And now i tried with straight table and it works

Thanks a lot

Re: Average expression shows values not average

Or — Wed, 24 Mar 2021 20:33:29 GMT

Great! Rule of thumb is to never use Table Box unless you have a really good reason. Straight table is (almost?) always the better option. Glad you got it working.

Re: Average expression shows values not average

Petrolucio — Wed, 24 Mar 2021 20:34:58 GMT

Thanks again for the help, you saved me. Have a great day!