Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

% sales growth for the latest week

Hello,

I have sales data for W1, W2,...,W8, i need to calculate % sales growth for the latest week i.e. W8/Avg (W1,W2,...W7).

Regards,

Chaithra

4 Replies

Re: % sales growth for the latest week

W8/rangeavg(W1,W2,W3,W4,W5,W6,W7)


talk is cheap, supply exceeds demand
chauhans85
Esteemed Contributor

Re: % sales growth for the latest week

(     (W8-w7)/W7 )*100

if you want latest week over 2nd latest week

Not applicable

Re: % sales growth for the latest week

Thanks Gysbert for your quick response.

I need to calculate the % sales growth.

i.e. Week8 sales/Avg(W1 sales,..... to...W7 sales)

Re: % sales growth for the latest week

QlikCommunity Tip: How to get answers to your post?


talk is cheap, supply exceeds demand
Community Browser