Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kirmil
Contributor
Contributor

Creating a histogram based on table, created from the original fields

Hello guys,

I have the following situation:

I am loading data from an excel file in Qlik sense, which data contains of unique IDs, dates and points. Every unique ID has a couple of dates with different points so I create a table with unique IDs and the average points from the different dates.

Now, the problem is when I try to create a histogram based on that last column (unique IDs with average points) I am not able to create it.

Any ideas how should I do it?

Thanks,

Kiril

Labels (2)
2 Replies
Lisa_P
Employee
Employee

The histogram is looking at raw values, not aggregated, so you should be entering just the field you want to see the distribution from, no aggregation or dimensions.

kirmil
Contributor
Contributor
Author

Ok, but when I want to see the distribution of the data I have calculated as a vector of values how should I do it then?

In excel it is very simple to do it and I am pretty sure it is easy to do it here as well but I still can't figure it out.