Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Create user-defined Buckets in Qlikview

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.

9 Replies
Not applicable
Author

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.

http://www.quickqlearqool.nl/?p=733

sujeetsingh
Master III
Master III

can you please explain in detail.

Gysbert_Wassenaar

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Or post the example PDF file?

Peter

Not applicable
Author

 

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
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

Thank u..

Not applicable
Author

thank u..

Not applicable
Author

Thank u..