Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression of Percentage

NamesSubjectMarksTotal Marks
JohnScience55100
social65100
English75100
PeterScience80100
social90100
English55100
I want to Display Below Structure of Table in qlikview How?
NamesMarksPercentage
John19565%
Peter22575%
Percentage Expression?
1 Reply
suniljain
Master
Master

Load

Name,

( sum(Marks)/sum(Total_Marks))*100 as Percentage,

Sum(Marks) as Marks

From XYZ.qvd group by Name Order by Name;