Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

Re: source???

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

Re: source???

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

Re: source???

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.

Community Browser