Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Pivot table - precent of row

Hi,

I have a pivot table which contains

Dimension: Group,grades(100,90,80,70,60,50)

Expression: Count (Students)

and the pivot look like this

GroupGrades1009080706050
A 80404040--
B --20202040
C 2-----
D ----3020

I want to know in each row the percent of student in each grade out of the group, how can i Do that?

Thanks,

Jacob

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Pivot table - precent of row

Count(Students)/count(total <Group> Students)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: Pivot table - precent of row

Count(Students)/count(total <Group> Students)


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

Re: Pivot table - precent of row

Gr8 thanks