topic Re: Defining Dynamic Buckets at runtime in QlikView

Defining Dynamic Buckets at runtime

Mon, 24 Mar 2014 09:12:18 GMT

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

Re: Defining Dynamic Buckets at runtime

sushil353 — Mon, 24 Mar 2014 09:14:28 GMT

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

~Sushil

Re: Defining Dynamic Buckets at runtime

sushil353 — Mon, 24 Mar 2014 09:15:06 GMT

Also check CLASS function in qlikview

HTH

Sushil

Re: Defining Dynamic Buckets at runtime

its_anandrjs — Mon, 24 Mar 2014 09:18:44 GMT

Hi,

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

Hope this helps

Thanks & Regards

Re: Defining Dynamic Buckets at runtime

jonathandienst — Mon, 24 Mar 2014 09:25:28 GMT

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

Re: Defining Dynamic Buckets at runtime

MK_QSL — Mon, 24 Mar 2014 09:28:14 GMT

May be attached file can help you..

Re: Defining Dynamic Buckets at runtime

Mon, 24 Mar 2014 09:57:05 GMT

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

Re: Defining Dynamic Buckets at runtime

MK_QSL — Mon, 24 Mar 2014 10:02:25 GMT

You can use my application to create pivot table.

Re: Defining Dynamic Buckets at runtime

MarcoWedel — Mon, 24 Mar 2014 10:06:00 GMT

grouping dimension values

Maybe this helps?

Regards

Marco