topic Re: How to Create user-defined Buckets in Qlikview in QlikView

How to Create user-defined Buckets in Qlikview

Fri, 27 Dec 2013 06:28:20 GMT

ya, iam trying to Create a report using a pdf file there i have cme across this concept.

i have no idea about it so plz help me out.

Thanks.

Fri, 27 Dec 2013 06:35:40 GMT

Hi Sravani,

There are many types of methods are there into QlikView to create the Bucket,

i am not sure for which you are looking,

please refer this link it may help you.

sujeetsingh — Fri, 27 Dec 2013 06:37:43 GMT

can you please explain in detail.

Gysbert_Wassenaar — Fri, 27 Dec 2013 06:47:53 GMT

Maybe one of these two blog posts helps:

Peter_Cammaert — Fri, 27 Dec 2013 09:59:49 GMT

Or post the example PDF file?

Peter

Fri, 27 Dec 2013 10:04:53 GMT

Bucket Analysis

The end user should be able to look at treatment information (total sales and number

of treatments) based on price of the treatment. This information should be displayed

in user-defined buckets. For example, the user should be able to set a bucket width of

$100 and the analysis will display sales and counts based on these buckets.

this is how it is explained in PDF file.

Peter_Cammaert — Fri, 27 Dec 2013 10:52:42 GMT

You can use two nice features of dimensions in Charts:

Dynamic dimensions: create a dimension on the fly instead of based on actual field values
Class() function: categorize field values in buckets of a given width

Now for the real thing:

Create a variable called vBucketWidth. This variable will contain the current user-selected bucket width
Create a slider object that sets variable vBucketWidth to a value between a reasonable minimum and maximum value (e.g. 10 to 1000)
Create a chart width your preferred aggregation functions (nothing complex needed here) and a single dynamic dimension: = Class(TreatementPrice, $(vBucketWidth))

Only caveat: I don't think there is any way of changing the dimension values. They're always expressed as something like '100<=x<200'.

Good luck,

Peter

Wed, 01 Jan 2014 15:23:40 GMT

Thank u..

Wed, 01 Jan 2014 15:24:13 GMT

thank u..

Wed, 01 Jan 2014 15:24:32 GMT

Thank u..