topic Re: Grouping score in QlikView

Grouping score

rkpatelqlikview — Sat, 16 Jun 2018 10:58:03 GMT

Dear Qlik,

Can please help on this?

I tried to get the score for teacher but i need to get the score by Branch based on the teacher.

Score and Branchscore has to be done in the backend.

I done the score but not Branchscore. I did by using "Group by branch". but am facing some problem with group by.

Example:

Branch: CSE is having 3 teachers here i want to see the score overall CSE, It should consider all the teachers belongs to CSE.

like below Excel.

rubenmarin — Sat, 16 Jun 2018 11:35:40 GMT

Hi Kumar, you can try with:

Sum(Total <Date, Branch> Points)/Sum(Total <Date, Branch> Lgrade)*1000

rkpatelqlikview — Sat, 16 Jun 2018 11:52:30 GMT

Thanks for great support Rubben,

Yes exactly which we you have done in straight table, can we do in the backend.

I did by using groub by in the backend. Will it be correct?

petter — Sat, 16 Jun 2018 11:56:47 GMT

Yes - you can do it like this:

SET DateFormat='M/D/YYYY';

SCORES:

LOAD

Date(Date)&'|'&Branch AS %DB,

Date,

Branch,

teacher,

Points,

Lgrade,

Score as Score_,

Branchscore as Branchscore_

FROM

(ooxml, embedded labels, table is Sheet1);

BRANCHSCORES:

LOAD

Date&'|'&Branch AS %DB,

Sum(Points)/Sum(Lgrade)*1000 AS Branchsocre

RESIDENT

SCORES

GROUP BY

Date,Branch;

rkpatelqlikview — Sat, 16 Jun 2018 13:05:33 GMT

Many Thanks Petter,

Great help. Its working properly now