topic Re: Resident Load Help in QlikView

Resident Load Help

Wed, 10 Jun 2015 17:00:19 GMT

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 — Wed, 10 Jun 2015 17:12:07 GMT

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;

Thu, 11 Jun 2015 15:45:18 GMT

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 — Thu, 11 Jun 2015 15:58:23 GMT

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.