Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor III

Re: Stacked bar chart in a table - Ideas?

Hi Cristian,

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

Regards,

MB

balrajahlawat
Esteemed Contributor

Re: Stacked bar chart in a table - Ideas?

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

Re: Stacked bar chart in a table - Ideas?

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

Re: Stacked bar chart in a table - Ideas?

   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

Re: Stacked bar chart in a table - Ideas?

Hi Miguel,

Any luck with the charts I was talking about?

Thanks in advance.

Community Browser