To get Top 5 last week

[#1]

Hello Friends,

I am trying to get the list of items which has maximum sale during the last week. I am using rank with set analysis to achieve this, however it only works when period is excluded.

Another requirement is to get the top most item sold for each week on rolling 12 basis. Can someone please help me with this.

Attached is the document with sample data.

Regards,

[sundarakumar]

To avoid selection of period excluding ur set analysis value u will have to add it to set analysis like

sum({<saledate={">=vDateFrom<=vDateTo",Period=}>}sales) This will make qlikview to ignore any selection in period.

To get rolling 12 months values create similar variables which denotes the start and end date of ur 12 month period.

-Sundar

[Anonymous · Accepted solution]

In the chart dimension put the Prticular dimension,

in the expression formula is:

=if(rank(sum({<[Sale Date]={"$(= '>=' & date(VStartDate) & '<=' & date(VEndDate))"}>} [Prices Sold]),Perticular)<=5,

  sum({<[Sale Date]={"$(= '>=' & date(VStartDate) & '<=' & date(VEndDate))"}>} [Prices Sold])

)

[#4]

Thanks for your help. This works perfectly for one weeks table however need to work out to for my second requirement to get the top item for each week for last 12 weeks.