Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Karahs
Partner - Creator
Partner - Creator

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
sunny_talwar

Then try this:

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

View solution in original post

11 Replies
Digvijay_Singh

Use Class() function -

Dimension Class(Product,10)

Measure - Count(Product)

MK_QSL
MVP
MVP

May be use below as Dimension

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

Karahs
Partner - Creator
Partner - Creator
Author

hey,

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

MK_QSL
MVP
MVP

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

Karahs
Partner - Creator
Partner - Creator
Author

I have attched sample qvf

sunny_talwar

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.

Karahs
Partner - Creator
Partner - Creator
Author

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 !!

sunny_talwar

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?

Karahs
Partner - Creator
Partner - Creator
Author

DImesion is AtmCode