Discussion Board for collaboration on QlikView Scripting.
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
'Q' & Ceil(Month(OrderDate)/3) as Quarter,
Dual('Q' & Ceil(Month(OrderDate)/3) & '-' & Year(OrderDate),
Year(OrderDate) & Ceil(Month(OrderDate)/3)) as QtrYear,
Try something like :
If( (Today() - OrderDate)<31, ORDER) as Last30DaysOrded,
If( (Today() - OrderDate)>30 AND (Today() - OrderDate)>61, ORDER) as 31to60DaysOrded
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
and review the example named "Assigning dates to temporal groups such as "Yesterday".".
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.