Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
4 Replies
MK_QSL
MVP
MVP

Provide Sample Data Please...

You can try with ValueList Function.....

its_anandrjs
Champion III
Champion III

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
MVP
MVP

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