Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
SunilChauhan
Champion
Champion

(     (W8-w7)/W7 )*100

if you want latest week over 2nd latest week

Sunil Chauhan
Not applicable
Author

Thanks Gysbert for your quick response.

I need to calculate the % sales growth.

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

Gysbert_Wassenaar

QlikCommunity Tip: How to get answers to your post?


talk is cheap, supply exceeds demand