Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-05-20 07:33 PM

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

1,438 Views
0 Replies