topic Re: Stacked bar chart in a table - Ideas? in QlikView

Stacked bar chart in a table - Ideas?

Mon, 18 Jan 2016 11:37:53 GMT

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

Re: Stacked bar chart in a table - Ideas?

miguelbraga — Mon, 18 Jan 2016 11:53:05 GMT

Hi Cristian,

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

Regards,

Re: Stacked bar chart in a table - Ideas?

Anonymous — Mon, 18 Jan 2016 12:07:00 GMT

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

Re: Stacked bar chart in a table - Ideas?

Mon, 18 Jan 2016 13:13:37 GMT

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.

Re: Stacked bar chart in a table - Ideas?

Mon, 18 Jan 2016 13:21:57 GMT

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 Name	Grade	student Name	Test Score	Proficiency Level
School 1	1	Student 1	8	Fail
School 1	1	Student 2	9	Fail
School 1	2	Student 3	9	Pass
School 1	2	Student 4	10	Pass
School 1	3	Student 5	10	Advanced
School 2	1	Student 6	8	Fail
School 2	1	Student 7	9	Fail
School 2	1	Student 8	9	Pass
School 2	2	Student 9	10	Pass
School 2	2	Student 10	10	Advanced

Re: Stacked bar chart in a table - Ideas?

Thu, 21 Jan 2016 15:06:13 GMT

Hi Miguel,

Any luck with the charts I was talking about?

Thanks in advance.