Discussion Board for collaboration related to QlikView App Development.
Hi to all,
Hoping you can help me,
I have a table of invoices, for each line in the script, i need to calculate the avg.price of the item with the same currency for the past 12 month and not does not include the line.
Here is a sample of my data:
Hope you can help me with the script
Thanks a head,
You can use peek() like:
RangeAvg(Peek('Price'), Peek('Price', -2), .....Peek('Price', -12)) as AvgPrice