topic Ageing Analysis - with bucket logic data source at Ms-Navision 5.00 Version in QlikView https://community.qlik.com/t5/QlikView/Ageing-Analysis-with-bucket-logic-data-source-at-Ms-Navision-5/m-p/738797#M264056 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Does anybody have charts of calculating age wise outstanding of stock (Inventory ) logic from MS Navision System ,</P><P></P><P>Please share logic how to do this.</P><P>-----------------------------------------------------------------------------------------------------------------</P><P><STRONG>Item Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0-30&nbsp;&nbsp;&nbsp;&nbsp; 31-60&nbsp;&nbsp;&nbsp; 61-90&nbsp;&nbsp;&nbsp; 91-180&nbsp;&nbsp;&nbsp; &gt;180&nbsp;&nbsp;&nbsp; Tot Inv Value</STRONG> </P><P>-----------------------------------------------------------------------------------------------------------------</P><P>Xyz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80 </P><P></P><P></P><P></P><P>Vikas</P></BODY></HTML> Wed, 09 Jul 2014 12:01:34 GMT vikasmahajan 2014-07-09T12:01:34Z Ageing Analysis - with bucket logic data source at Ms-Navision 5.00 Version https://community.qlik.com/t5/QlikView/Ageing-Analysis-with-bucket-logic-data-source-at-Ms-Navision-5/m-p/738797#M264056 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Does anybody have charts of calculating age wise outstanding of stock (Inventory ) logic from MS Navision System ,</P><P></P><P>Please share logic how to do this.</P><P>-----------------------------------------------------------------------------------------------------------------</P><P><STRONG>Item Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0-30&nbsp;&nbsp;&nbsp;&nbsp; 31-60&nbsp;&nbsp;&nbsp; 61-90&nbsp;&nbsp;&nbsp; 91-180&nbsp;&nbsp;&nbsp; &gt;180&nbsp;&nbsp;&nbsp; Tot Inv Value</STRONG> </P><P>-----------------------------------------------------------------------------------------------------------------</P><P>Xyz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80 </P><P></P><P></P><P></P><P>Vikas</P></BODY></HTML> Wed, 09 Jul 2014 12:01:34 GMT https://community.qlik.com/t5/QlikView/Ageing-Analysis-with-bucket-logic-data-source-at-Ms-Navision-5/m-p/738797#M264056 vikasmahajan 2014-07-09T12:01:34Z Re: Ageing Analysis - with bucket logic data source at Ms-Navision 5.00 Version https://community.qlik.com/t5/QlikView/Ageing-Analysis-with-bucket-logic-data-source-at-Ms-Navision-5/m-p/738798#M264057 <HTML><HEAD></HEAD><BODY><P>You can use the class function nested in an if statement:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; if(Something&gt;180,'&gt;180', class(Something,30)) as BucketsOfSomething</P><P>&nbsp;&nbsp;&nbsp;&nbsp; FieldX,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; FieldY,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; etc</P><P>From ...somewhere...</P></BODY></HTML> Wed, 09 Jul 2014 12:04:50 GMT https://community.qlik.com/t5/QlikView/Ageing-Analysis-with-bucket-logic-data-source-at-Ms-Navision-5/m-p/738798#M264057 Gysbert_Wassenaar 2014-07-09T12:04:50Z