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: 
Anonymous
Not applicable

How to first rank items then find the week on week sales of the items?

Hi everyone, I am trying to create a table that first rank the brands (top 5) by sales volume, grouped by product category. Then, for each of the top 5 brands, find the week on week sales performance.

Product Cat.

Brand RankBrandSalesSales LWDelta
X1ABC$1200$100020%
2DEF$500$1000-50%
3FG$1000100%
4HH$50$25200%
5IJ$10$100%
Y1AA$500$100500%
2BB$300$600-50%
3CC$200$100100%
4

DD

$150$1000-85%
5EE$100$200-50%
Z1
2

Any possible solution is welcomed. Thanks in advance.


Cheers,

Eng Xiong

5 Replies
Gysbert_Wassenaar

Can you post a small qlikview document with example data?


talk is cheap, supply exceeds demand
lironbaram
Partner - Master III
Partner - Master III

hi

Have a look at the attach example

ramoncova06
Specialist III
Specialist III

I don't see the week to week in your example, can you add that in

Anonymous
Not applicable
Author

Hey,

Thanks for the great example. Very helpful.

lironbaram
Partner - Master III
Partner - Master III

glad it helped you