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