topic need Urgent help ,stock somewhere in QlikView https://community.qlik.com/t5/QlikView/need-Urgent-help-stock-somewhere/m-p/563364#M694249 <HTML><HEAD></HEAD><BODY><P>I have been challenging to work with my dashboard report Orders with in last 30 days Orders between 31- 60 days Orders between 60 - 90 days Orders between 90 - 180 days Orders 180 and beyond right now my script looks like this this [OrderData]: LOAD&nbsp;&nbsp;&nbsp;&nbsp; OrderID,&nbsp;&nbsp;&nbsp;&nbsp; CustomerID,&nbsp;&nbsp;&nbsp;&nbsp; EmployeeID,&nbsp;&nbsp;&nbsp;&nbsp; OrderDate,&nbsp;&nbsp;&nbsp;&nbsp; Year(OrderDate) as Year,&nbsp;&nbsp;&nbsp;&nbsp; Month(OrderDate) as&nbsp; Month,&nbsp;&nbsp;&nbsp;&nbsp; Week(OrderDate) as Week,&nbsp;&nbsp;&nbsp;&nbsp; RequiredDate,&nbsp;&nbsp;&nbsp;&nbsp; ShippedDate,&nbsp;&nbsp;&nbsp;&nbsp; ShipVia,&nbsp;&nbsp;&nbsp;&nbsp; Freight,&nbsp;&nbsp;&nbsp;&nbsp; ShipName,&nbsp;&nbsp;&nbsp;&nbsp; ShipAddress,&nbsp;&nbsp;&nbsp;&nbsp; ShipCity,&nbsp;&nbsp;&nbsp;&nbsp; ShipRegion,&nbsp;&nbsp;&nbsp;&nbsp; ShipPostalCode,&nbsp;&nbsp;&nbsp;&nbsp; ShipCountry FROM <C> (biff, embedded labels, table is Orders); [MaxDate]: LOAD Max([OrderDate]) As [MaxDate] Resident [OrderData]; Let varMaxDate = Peek('MaxDate',0,'MaxDate');&nbsp; Drop Table [MaxDate];&nbsp; [OrderData2]: LOAD&nbsp;&nbsp;&nbsp;&nbsp; *,&nbsp;&nbsp;&nbsp;&nbsp; If($(varMaxDate)-[OrderDate]&lt;31, '0-30',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If($(varMaxDate)-[OrderDate]&lt;61, '30-61',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If($(varMaxDate)-[OrderDate]&lt;91, '60-90',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If($(varMaxDate)-[OrderDate]&lt;181, '90-180',&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;&nbsp;&nbsp;&nbsp; If($(varMaxDate)-[OrderDate]&gt;180, 'Over 181'&nbsp;&nbsp;&nbsp;&nbsp; ))))) AS [OrderAging] Resident [OrderData];&nbsp;&nbsp; Drop Table [OrderData];</C></P></BODY></HTML> Thu, 11 Jul 2013 15:27:37 GMT 2013-07-11T15:27:37Z need Urgent help ,stock somewhere https://community.qlik.com/t5/QlikView/need-Urgent-help-stock-somewhere/m-p/563364#M694249 <HTML><HEAD></HEAD><BODY><P>I have been challenging to work with my dashboard report Orders with in last 30 days Orders between 31- 60 days Orders between 60 - 90 days Orders between 90 - 180 days Orders 180 and beyond right now my script looks like this this [OrderData]: LOAD&nbsp;&nbsp;&nbsp;&nbsp; OrderID,&nbsp;&nbsp;&nbsp;&nbsp; CustomerID,&nbsp;&nbsp;&nbsp;&nbsp; EmployeeID,&nbsp;&nbsp;&nbsp;&nbsp; OrderDate,&nbsp;&nbsp;&nbsp;&nbsp; Year(OrderDate) as Year,&nbsp;&nbsp;&nbsp;&nbsp; Month(OrderDate) as&nbsp; Month,&nbsp;&nbsp;&nbsp;&nbsp; Week(OrderDate) as Week,&nbsp;&nbsp;&nbsp;&nbsp; RequiredDate,&nbsp;&nbsp;&nbsp;&nbsp; ShippedDate,&nbsp;&nbsp;&nbsp;&nbsp; ShipVia,&nbsp;&nbsp;&nbsp;&nbsp; Freight,&nbsp;&nbsp;&nbsp;&nbsp; ShipName,&nbsp;&nbsp;&nbsp;&nbsp; ShipAddress,&nbsp;&nbsp;&nbsp;&nbsp; ShipCity,&nbsp;&nbsp;&nbsp;&nbsp; ShipRegion,&nbsp;&nbsp;&nbsp;&nbsp; ShipPostalCode,&nbsp;&nbsp;&nbsp;&nbsp; ShipCountry FROM <C> (biff, embedded labels, table is Orders); [MaxDate]: LOAD Max([OrderDate]) As [MaxDate] Resident [OrderData]; Let varMaxDate = Peek('MaxDate',0,'MaxDate');&nbsp; Drop Table [MaxDate];&nbsp; [OrderData2]: LOAD&nbsp;&nbsp;&nbsp;&nbsp; *,&nbsp;&nbsp;&nbsp;&nbsp; If($(varMaxDate)-[OrderDate]&lt;31, '0-30',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If($(varMaxDate)-[OrderDate]&lt;61, '30-61',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If($(varMaxDate)-[OrderDate]&lt;91, '60-90',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If($(varMaxDate)-[OrderDate]&lt;181, '90-180',&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;&nbsp;&nbsp;&nbsp; If($(varMaxDate)-[OrderDate]&gt;180, 'Over 181'&nbsp;&nbsp;&nbsp;&nbsp; ))))) AS [OrderAging] Resident [OrderData];&nbsp;&nbsp; Drop Table [OrderData];</C></P></BODY></HTML> Thu, 11 Jul 2013 15:27:37 GMT https://community.qlik.com/t5/QlikView/need-Urgent-help-stock-somewhere/m-p/563364#M694249 2013-07-11T15:27:37Z Re: need Urgent help ,stock somewhere https://community.qlik.com/t5/QlikView/need-Urgent-help-stock-somewhere/m-p/563365#M694250 <HTML><HEAD></HEAD><BODY><P>Your post is hardly comprehensible. If you need your question to be answered, you have to reach to the people. Have a look here: </P><P><A href="https://community.qlik.com/docs/DOC-2380">QlikCommunity Tip: How to get answers to your post?</A></P></BODY></HTML> Thu, 11 Jul 2013 18:02:55 GMT https://community.qlik.com/t5/QlikView/need-Urgent-help-stock-somewhere/m-p/563365#M694250 tresB 2013-07-11T18:02:55Z Re: need Urgent help ,stock somewhere https://community.qlik.com/t5/QlikView/need-Urgent-help-stock-somewhere/m-p/563366#M694251 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>It seen the previouse post I used to follow. So what is problem here?</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Fri, 12 Jul 2013 01:21:42 GMT https://community.qlik.com/t5/QlikView/need-Urgent-help-stock-somewhere/m-p/563366#M694251 Sokkorn 2013-07-12T01:21:42Z