
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Defining Dynamic Buckets at runtime
Hi Guys,
Long time no see ..
I have a column called "Value",which contains Actual data of Numeric values. I want to plot actual vs planned data.
But the catch is I need a mechanism to define buckets of the field "Value" in batches of 1000 at runtime.
I have calculated a minimum and maximum value of this field,but I somehow cannot figure out how to define buckets at runtime,because
its value ranges are very inconsistent.
Kindly help ,as this is on priority for me.
Thanks guys,
Rochelle


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
could you provide a dataset and then explain your requirement in detail.
~Sushil


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Also check CLASS function in qlikview
HTH
Sushil

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Use variables for dynamic bucketing and make bucket on the front end.
Hope this helps
Thanks & Regards


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
If you mean buckets of 1000, then
=Class(Value, 1000)
as a calculated dimension. If you want the buckets to respond to user changes, create a variable (say vBucket) with an input box or slider, and use the variable name in place of 1000:
=Class(Value, vBucket)
HTH
Jonathan

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be attached file can help you..

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Guys ,
Allow me to explain the precise requirement:
PFA the attached.
My objective is that I need to plot operating hours of a machine Vs the faults it has encountered in those hours.
The buckets(as in the attached) are operating hours divided in ranges of 1000.Every failure has a code defined in the master which I have linked with my data model.
The buckets are to be plotted dynamically,because the operating hours are very inconsistent.
Kindly Suggest.
Best,
Rochelle

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use my application to create pivot table.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
