source???

[#1]

i am woundering how to learn about script or change in the script.is there any source i can know about the script.when i do CTRL+E.Im stuck in the making my

1. Orders with in last 30 days
2. Orders between 31- 60 days
3. Orders between 60 - 90 days
4. Orders between 90 - 180 days
5. Orders 180 and beyondand
8. my script looks lik this right now

  CustomerID,

     EmployeeID,

     OrderDate,

     Year(OrderDate)as OrderYear,

     'Q' & Ceil(Month(OrderDate)/3) as Quarter,

     Dual('Q' & Ceil(Month(OrderDate)/3) & '-' & Year(OrderDate),

     Year(OrderDate) & Ceil(Month(OrderDate)/3)) as QtrYear,

     RequiredDate,

[tresesco]

Try something like :

Load

        CustomerID,

        EmployeeID,

        OderDate,

        If( (Today() - OrderDate)<31, ORDER) as Last30DaysOrded,

        If( (Today() - OrderDate)>30  AND (Today() - OrderDate)>61, ORDER) as 31to60DaysOrded     

...

and similarly

[rwunderlich]

One solution is to assign the OrderDate values to "Range groups". For an an example of how to do this, download the QV Cookbook from

http://robwunderlich.com/downloads

and review the example named "Assigning dates to temporal groups such as "Yesterday".".

-Rob

http://masterssummit.com

http://robwunderlich.com

[#4]

Thanks Rob for for the cookbook.this is the types of source i am looking for since i am new to qlikview.

If you have some more source in qlikview that will be appreciated.