Resident Load Help

[#1]

HI Experts

I am doing a resident load

my objective is to show top 5 sales for each branch

But I am Stuck in Doing the Resident Load

Please Suggest

[maxgro · Accepted solution]

if you want top 5 in the script replace your S3 with

S3:

load * where id <= 5;

noconcatenate load

  *,

  if(peek(Branch)=Branch, peek(id)+1, 1) as id

Resident S2

order by Branch, SalesAmt desc;    

[#3]

Hi Massimo

In my Qvw I having Sales data for two Months April & May and 2 Branches

My requirement is to show top 10 With Max Sales For each branch

But if  I select May my Condition Working, but Not working for April

Got Stuck With This, Please Help

[buzzy996]

u can also try with dimension limits tab options,for the same..u can achieve the same result and simply way instituted of wring code in backend.