topic How do i create a normalized histogram? in QlikView https://community.qlik.com/t5/QlikView/How-do-i-create-a-normalized-histogram/m-p/159617#M34195 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to create a trellis chart with normalized histograms.</P><P>I managed to create a histogram by using a calculated dimension</P><P>=Class(Aggr(Sum(Mips),CEC,Timestamp),Histogram_bin_size)</P><P>and the expression</P><P></P><P>Count(Aggr(Sum(Mips),Timestamp,CEC))</P><BR /><BR /> <P>(My data granularity is timestamp and Lpar (a CEC has a number of Lpars), I am interested in the histogram for one CEC.</P><P>How can i normalize the histograms? Something like dividing by Count(Timestamp), but this doesn't seem to work.</P><P></P><P>Help is very much appreciated.</P><P></P><P>/Rickard</P></BODY></HTML> Thu, 20 May 2010 23:33:57 GMT 2010-05-20T23:33:57Z How do i create a normalized histogram? https://community.qlik.com/t5/QlikView/How-do-i-create-a-normalized-histogram/m-p/159617#M34195 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to create a trellis chart with normalized histograms.</P><P>I managed to create a histogram by using a calculated dimension</P><P>=Class(Aggr(Sum(Mips),CEC,Timestamp),Histogram_bin_size)</P><P>and the expression</P><P></P><P>Count(Aggr(Sum(Mips),Timestamp,CEC))</P><BR /><BR /> <P>(My data granularity is timestamp and Lpar (a CEC has a number of Lpars), I am interested in the histogram for one CEC.</P><P>How can i normalize the histograms? Something like dividing by Count(Timestamp), but this doesn't seem to work.</P><P></P><P>Help is very much appreciated.</P><P></P><P>/Rickard</P></BODY></HTML> Thu, 20 May 2010 23:33:57 GMT https://community.qlik.com/t5/QlikView/How-do-i-create-a-normalized-histogram/m-p/159617#M34195 2010-05-20T23:33:57Z