Weekly diffrence calculation

[srinivasa1]

Hi,

Can anyone guide me how can calcaulate weekly diffrence in qlikview pivot table in best way. below is my sample requirements

I have attached my sample application..i need to label as dynamic for weekend and need to calcualte sales weekly variance based on weekeend

Thanks for any guidence

[jagan]

Hi Srinivas,

Instead calculating in Pivot table, this can be easily done in script while loading using Order by and Previous function.

LOAD

*,

If(Previous(Product) = Product, Previous(Sales) - Sales, 0) AS Difference

FROM Datasource

Order by Product, Date Desc;

Hope this helps you.

Regards,

Jagan.