Defining Dynamic Buckets at runtime

[#1]

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

[sushil353]

could you provide a dataset and then explain your requirement in detail.

~Sushil

[sushil353]

Also check CLASS function in qlikview

HTH

Sushil

[its_anandrjs]

Hi,

Use variables for dynamic bucketing and make bucket on the front end.

Hope this helps

Thanks & Regards

[jonathandienst]

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

[MK_QSL]

May be attached file can help you..

[#7]

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

[MK_QSL]

You can use my application to create pivot table.

[MarcoWedel]

grouping dimension values

Maybe this helps?

Regards

Marco