topic Re: source??? in QlikView

source???

Tue, 09 Jul 2013 03:08:54 GMT

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

Orders with in last 30 days
Orders between 31- 60 days
Orders between 60 - 90 days
Orders between 90 - 180 days
Orders 180 and beyondand
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,

Re: source???

tresB — Tue, 09 Jul 2013 04:22:43 GMT

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???

rwunderlich — Tue, 09 Jul 2013 05:28:01 GMT

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

Re: source???

Thu, 11 Jul 2013 06:36:03 GMT

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.