topic Re: Buckets data? in QlikView

Buckets data?

Wed, 05 Nov 2014 16:56:23 GMT

HI All,

I have created Buckets with 0-3 Months, 3-6 Months,9-6 Months & So on...

I have the Total QTY--30 as per the aging concept it was distributed in the buckets, and also I need to See Total QTY as 30 also in the One Column in Pivot Table...

Regards,

Helen

Re: Buckets data?

MK_QSL — Wed, 05 Nov 2014 16:58:15 GMT

Provide Sample Data Please...

You can try with ValueList Function.....

Re: Buckets data?

its_anandrjs — Wed, 05 Nov 2014 17:04:07 GMT

Hi,

You can use the class function below is from QV help

class(expression, interval [ , label [ , offset ]])

Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'

Regards

Anand

Re: Buckets data?

Wed, 05 Nov 2014 17:07:36 GMT

I have already created Buckets based on QTY...

The thing is I need to See total QTY which has bifurcted among buckets...

Re: Buckets data?

MarcoWedel — Wed, 05 Nov 2014 22:18:01 GMT

Hi Helen,

does this question refer to the sample application you posted here:

Stock Aging buckets ?

wherein you are using a calculated dimension I proposed in this thread:

Re: Re: Stock Aging Buckets ?

which you refused to close stating your initial question has not been answered?

thanks

regards

Marco