topic Re: Weekly diffrence calculation in QlikView

Weekly diffrence calculation

srinivasa1 — Thu, 07 Mar 2013 14:58:13 GMT

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 — Thu, 07 Mar 2013 15:02:59 GMT

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.