Bucket Calculation

[#1]

Hi All

I have a date field  which represents  Item used on  , now I want to calculate Buckets for every Item with an interval of 6 months from its first usage when user selects on 6 Months I would like to calculate sum of  lent for each item, from its first usage date. can any one help me on this how to get it done.

Regards

John

[Anonymous]

Did you check this?

Buckets

Making Buckets while loading data

Creating Aging Buckets within QlikView

Creating Buckets in the Load Script

[miguelbraga]

Check this out John:

https://community.qlik.com/docs/DOC-4252

It may help you.

Regards,

MB

[Anonymous]

Hi,

You can use the function addmonths to calculate the 6 last months:

Add a button with an action like this:

If your date field is named "Date" : the action will be select in a field:

='>='&AddMonths(Max(Date),-6)&'<='&Date(Max(Date))

Then your doc will be filtered in the last 6 months of your date.

You can also use rhis expression in a set analyses, example:

sum({<Date={" >=$(=AddMonths(Max(Date),-6)) <=$(=Date(Max(Date))) "}>}Sales)

[#5]

Thanks Sbobbyraj, unfortunately I need to calculate it on the data model script.