Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kshitijas
New Contributor III

Buckets from measure

Hello everyone,

How can i create buckets from measure?

Eg. I have Count(CallId) as total and want to create buckets for total. How can i achieve this?

Cant use class function because class function needs field not measure!

Thanks!!!

1 Solution

Accepted Solutions

Re: Buckets from measure

Then try this:

Aggr(Class(Count(CallID),10), AtmCode)

11 Replies
Digvijay_Singh
Honored Contributor III

Re: Buckets from measure

Use Class() function -

Dimension Class(Product,10)

Measure - Count(Product)

Re: Buckets from measure

May be use below as Dimension

Aggr(Class(Count(CallID),10),CallID)

kshitijas
New Contributor III

Re: Buckets from measure

hey,

Am only getting 0-10 bucket,i want 0-10,10,20,20-30,etc...

Re: Buckets from measure

Provide some data... you would get 0-10, 10-20, 20-30 if you have count(CallID) accordingly..

kshitijas
New Contributor III

Re: Buckets from measure

I have attched sample qvf

Re: Buckets from measure

This is a distinct list of CallLogID which is always 1. What dimension are you counting this CallLogID on? In the sample you have provided there is only one field, but I am guessing that you might have more dimension in your actual scenario.

kshitijas
New Contributor III

Re: Buckets from measure

Actually i want to create a listbox in which all the buckets are present ie.0-10,10-20,etc....

i already have a graph as below:

grphh.png

Thanks !!

Re: Buckets from measure

We sort of understand what you want, but what is still unclear is that what dimension are you counting CallLogID on? In other words, when you say Count(CallLogID) as expression, what is your dimension?

kshitijas
New Contributor III

Re: Buckets from measure

DImesion is AtmCode

Community Browser