Distribution and frequency table in Qlik sense

Mon, 12 Jun 2017 08:51:45 GMT

Hello,

I have a problem with a distribution and analysis of frequency in Qlik Sense.

First here is an example of my data,

Student	Module	Note
A	X	8
A	Y	9
A	Z	10
B	Y	11
B	Z	8
C	V	9
C	W	15
C	X	14
C	Y	17
C	Z	12.5

With that table I try to do several things:

1) Create an histogram with the distribution of the average for each student

2) Implement the distribution curve, For now I use the following function for the distribution of the grades but I cannot find the solution for the average per student

Only(Normdist(Round(

Note

,BinWidth),round(Avg(total

Note

)),round(Stdev(total

Note

)), 0))*BinWidth*Count(total

Note

)

With BinWidth = 1

3) the last step is to publish the frequency table with the number of exam passed as an entry.

The result should be as followed:

Number of exam passed	Frenquency	Cumul freq	%	Cumul %
1	0	0	0%	0%
2	1	1	33%	33%
3	1	2	33%	66%
4	0	2	0%	66%
5	1	3	33%	100%

The last line (first column) should equal the max number of exam passed and results without observations should be integrated as well (for example 4)

Thanks in advance

topic Distribution and frequency table in Qlik sense in App Development

Distribution and frequency table in Qlik sense