Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Buckets data?

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

4 Replies
MK_QSL
MVP
MVP

Provide Sample Data Please...

You can try with ValueList Function.....

its_anandrjs

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

Not applicable
Author

I have already created Buckets based on QTY...

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

MarcoWedel

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