Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
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
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
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.