Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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