Stock Aging Buckets ?

[#1]

I Need to Create Buckets for Stock Aging Report Like this....

Stock QTY   Stock Value  

0-3 Months   0-3 Months

3-6 Months   3-6 Months

6-9 Months   6-9 Months

9-12 Months  9-12 Months

1-2Years      1-2Years

2-3 Years      2-3 Years

2-3 Years    2-3 Years

>4Years      >4Years

How Can I acheive this Using Pivot Table with Some Other Dimensions& Expr...

Regards,

Helen

[#2]

Hi

Hope this help:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/07/14/buckets

Thanks!

[#3]

Hi Marco,

I am getting -QTy in Some Buckets...Could you please try & let me know..

In this Link I have mentioned briefly & attached App & EXcel file also..Please let me know

http://community.qlik.com/message/625321#625321

Regards,

Helen

[MarcoWedel]

Hi,

please close this thread if your initial question is answered and proceed this discussion in your newly created thread.

thanks

regards

Marco

[#5]

HI Marco,

My Issue was not resolved requirement was chaged a little bit...

please go through this link,  http://community.qlik.com/message/625321#625321

I have attached the Excel file data, Application.. I am getting Negative QTY..

Help me on this...

Thanks,

Helen