Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stacked bar chart in a table - Ideas?

Hi everyone,

Any idea about displaying a stacked column bar chart in a table in Qlikview 11?

I have student test scores and each score is associated with a proficiency level. (Fail,Pass,Advanced)

I need to display a percentage of F/P/A out of the total count of proficiency Levels as stacked bars. Why in a table? Because each row will display this information for multiple schools.

I calculated the percentages but I can't figure out how to display them in the same line as stacked columns.

Thanks a lot in advance for your ideas

5 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

Hi Cristian,

Can you please leave a qvd or a excel sample so we can make a solution for you?

Regards,

MB

Anonymous
Not applicable
Author

Like this?

Write 3 expression & use Stack style from properties:

Fail : Count({<Status={'Fail'>}disctinct StudentID)/Count(Total Disticnt StudentID)

//Here you can use it into % or integer format..

Replace Fail with Pass & advanced for others

Not applicable
Author

this is how i wrote my expressions:

=(Count(distinct {<[ProficiencyLevel] = {'Advanced'}>} TestScore) / Count(distinct  TestScore)  )*100

I wrote this in variables so i can use them as per attached screenshot.qv screenshot.png

Not applicable
Author

   Hi Miguel,

here's what I was able to do so far. Sorry for the data past. Cant't find how to attach an excel file.

School NameGradestudent NameTest ScoreProficiency Level
School 11Student 18Fail
School 11Student 29Fail
School 12Student 39Pass
School 12Student 410Pass
School 13Student 510Advanced
School 21Student 68Fail
School 21Student 79Fail
School 21Student 89Pass
School 22Student 910Pass
School 22Student 1010Advanced

qv screenshot.png

Not applicable
Author

Hi Miguel,

Any luck with the charts I was talking about?

Thanks in advance.