Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
engxiongster
Contributor
Contributor

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
Partner

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

engxiongster
Contributor
Contributor
Author

Hey,

Thanks for the great example. Very helpful.

lironbaram
Partner
Partner

glad it helped you