5 Replies Latest reply: Jan 19, 2017 7:42 AM by Onno van Knotsenburg

# Histogram of histogram

Hello community!

I am a basic but regular user of Qlik Sense, I try to represent several aggregations of data from an excel file (from a log file) and I hold on the representation ...

The Excel file contains only one table with the Date (dd / mm / yyyy) columns, Weight (format #, ## Kg) and NumCommand (unique text ID).

I created a first histogram showing the number of orders / day (this one is easy)

Below I want to create a second histogram that shows the details of the weights / day so that by selecting a day in the first histogram, the detail of that day is displayed in the second histogram.

The detail is that in this second histogram, I have to present the data in the following way:

- Number of orders per 10Kg range from 0 to 50Kg

- Number of orders per 50Kg range from 50 to 250Kg

- Number of orders per 800Kg range from 250 to 800Kg, 800 to 1600Kg and 1600 to 2400Kg

I am open to other representations, I have tried with a pivot table (rows and columns are ok) but I can not translate it into a graphical representation after ...

The ideal image concept (photo editing)

• ###### Re: Histogram of histogram

for the second histogram you can create a Dimension using Class() finction.

Try using Class with Set analysis to define the range (10 kg / 50 Kg / 800 kg)

lets try to develop with just one range first  and we can then take it forward from there.

Share  what you find

• ###### Re: Histogram of histogram

Please, could you be more specific about a Dimension using "Set Analysis" and "Class", I looked at these functions but I didn't find how to implement it in my usecase...

• ###### Re: Histogram of histogram

Hi Olivier,

Dimension of histogram:

If(Weight < 50, Class(Weight, 10),

If(Weight >= 50 And Weight < 250, Class(Weight, 50),

If(Weight >= 250 And Weight < 800, Class(Weight, 550,'x',250),

Class(Weight, 800)

)))

histogram expression:  Count(NumCommand).

A chart should be sorted alphabetically by dimension.

Regards,

Andrey

• ###### Re: Histogram of histogram

Thank you for your quick reply, it works fine and now I understood how it works!