Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mharm
Contributor

Re: count aggr sum

I believe this works.  thank you.  now I'd like to make a histogram of the results.  I was thinking I'd make a dimension like this..

ValueList('0-2','3-5','6-8','9-11','12-14','15-17','18-20','21-23','24-26')

but then how would I get the correct values as the measures?  would I chart the results from above with an if statement to match the intervals in the value list?

MVP
MVP

Re: count aggr sum

What are these intervals here? These are related to the calculated avg above?

Highlighted
mharm
Contributor

Re: count aggr sum

so let's say that the original question I had yielded these results

marco a - 3 people have hours in this macro

macro b - 2 people have hours in this macro

macro c - 6

macro d -17

macro e - 10

marco f - 3

macro g - 2

macro h - 6

macro i -17

macro j - 10

now I want to chart that 2 macros had between 0-2 people, 2 macros had between 3-5 people, 2 macros had between 6-8 people...etc..