Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Names | Subject | Marks | Total Marks | |||
John | Science | 55 | 100 | |||
social | 65 | 100 | ||||
English | 75 | 100 | ||||
Peter | Science | 80 | 100 | |||
social | 90 | 100 | ||||
English | 55 | 100 | ||||
I want to Display Below Structure of Table in qlikview How? | ||||||
Names | Marks | Percentage | ||||
John | 195 | 65% | ||||
Peter | 225 | 75% | ||||
Percentage Expression? |
Load
Name,
( sum(Marks)/sum(Total_Marks))*100 as Percentage,
Sum(Marks) as Marks
From XYZ.qvd group by Name Order by Name;