Grouping score

[rkpatelqlikview]

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]

Hi Kumar, you can try with:

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

[rkpatelqlikview]

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 · Accepted solution]

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]

Many Thanks Petter,

Great help. Its working properly now