Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

source???

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
  6. 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,

3 Replies
tresesco
MVP
MVP

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

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.