topic Re: Bucket Calculation in QlikView

topic Re: Bucket Calculation in QlikView https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064611#M941234 <HTML><HEAD></HEAD><BODY><P>Thanks Sbobbyraj, unfortunately I need to calculate it on the data model script. </P></BODY></HTML> Mon, 25 Jan 2016 12:05:08 GMT 2016-01-25T12:05:08Z Bucket Calculation https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064607#M941230 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>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  <STRONG>lent</STRONG> for each item, from its first usage date. can any one help me on this how to get it done. </P><P></P><P></P><P></P><P>Regards</P><P>John</P></BODY></HTML> Mon, 25 Jan 2016 10:41:44 GMT https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064607#M941230 2016-01-25T10:41:44Z Re: Bucket Calculation https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064608#M941231 <HTML><HEAD></HEAD><BODY><P>Did you check this?</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3821">Buckets</A></P><P></P><P><A href="https://community.qlik.com/thread/66860">Making Buckets while loading data</A></P><P></P><P><A href="https://community.qlik.com/thread/119623">Creating Aging Buckets within QlikView</A></P><P></P><P><A href="https://community.qlik.com/thread/74808">Creating Buckets in the Load Script</A></P></BODY></HTML> Mon, 25 Jan 2016 10:44:06 GMT https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064608#M941231 Anonymous 2016-01-25T10:44:06Z Re: Bucket Calculation https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064609#M941232 <HTML><HEAD></HEAD><BODY><P>Check this out John:</P><P></P><P><A class="jive-link-wiki-small" data-containerid="2049" data-containertype="14" data-objectid="4252" data-objecttype="102" href="https://community.qlik.com/docs/DOC-4252">https://community.qlik.com/docs/DOC-4252</A></P><P></P><P>It may help you.</P><P></P><P>Regards,</P><P>MB</P></BODY></HTML> Mon, 25 Jan 2016 10:48:59 GMT https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064609#M941232 miguelbraga 2016-01-25T10:48:59Z Re: Bucket Calculation https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064610#M941233 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use the function addmonths to calculate the 6 last months:</P><P>Add a button with an action like this:</P><P>If your date field is named "Date" : the action will be select in a field:</P><P>='>='&AddMonths(Max(Date),-6)&'<='&Date(Max(Date))</P><P></P><P>Then your doc will be filtered in the last 6 months of your date.</P><P></P><P>You can also use rhis expression in a set analyses, example:</P><P></P><P>sum({<Date={" <SPAN style="font-size: 13.3333px;">>=$(=AddMonths(Max(Date),-6)) <=$(=Date(Max(Date)))</SPAN> "}>}Sales)</P></BODY></HTML> Mon, 25 Jan 2016 10:55:48 GMT https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064610#M941233 Anonymous 2016-01-25T10:55:48Z Re: Bucket Calculation https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064611#M941234 <HTML><HEAD></HEAD><BODY><P>Thanks Sbobbyraj, unfortunately I need to calculate it on the data model script. </P></BODY></HTML> Mon, 25 Jan 2016 12:05:08 GMT https://community.qlik.com/t5/QlikView/Bucket-Calculation/m-p/1064611#M941234 2016-01-25T12:05:08Z