Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do i create a normalized histogram?

Hi,

I want to create a trellis chart with normalized histograms.

I managed to create a histogram by using a calculated dimension

=Class(Aggr(Sum(Mips),CEC,Timestamp),Histogram_bin_size)

and the expression

Count(Aggr(Sum(Mips),Timestamp,CEC))



(My data granularity is timestamp and Lpar (a CEC has a number of Lpars), I am interested in the histogram for one CEC.

How can i normalize the histograms? Something like dividing by Count(Timestamp), but this doesn't seem to work.

Help is very much appreciated.

/Rickard

0 Replies