topic Re: Sales By Month in QlikView

Sales By Month

Thu, 11 Jun 2015 15:43:45 GMT

HI Experts

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

Re: Sales By Month

Anonymous — Thu, 11 Jun 2015 15:53:28 GMT

Hi,

You have the option to restrict the top 10 in the dimension limits area.

However it looks like we don't have 10 Customers in April

Check and let me know

Regards

Jeba

Re: Sales By Month

buzzy996 — Thu, 11 Jun 2015 15:59:46 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.

Re: Sales By Month

Thu, 11 Jun 2015 16:00:21 GMT

Hi Dass

I want to choose Top Max 10 sales for each branch in April

Re: Sales By Month

Anonymous — Thu, 11 Jun 2015 16:03:24 GMT

pls check this one and confirm

Re: Sales By Month

Thu, 11 Jun 2015 16:05:51 GMT

Hi Shiva

I tried that, but not working as expected, so using this way

My actual requirement was choose 200 Top Highest Sales for each Branch

and Show worst 20 sales from that 200 list

Re: Sales By Month

ramoncova06 — Thu, 11 Jun 2015 16:06:11 GMT

you don't have any data for March, therefore whenever you select April the "Last Month Sales" is not showing anything

Re: Sales By Month

Thu, 11 Jun 2015 16:10:22 GMT

Re: Sales By Month

Thu, 11 Jun 2015 16:12:02 GMT

Hi Ramon

There are actually 30 transactions for April in that Excel Sheet

Re: Sales By Month

Anonymous — Thu, 11 Jun 2015 16:14:53 GMT

Are you using the same excel file.

Because your datamodel shows only 20 rows total !!

Re: Sales By Month

Thu, 11 Jun 2015 16:32:07 GMT

HI Dass

Yes

In the Script there is the restriction

Re: Sales By Month

ramoncova06 — Thu, 11 Jun 2015 17:14:34 GMT

I guess I do not understand your issue, the only thing that I am seeing as not populating any info when you select on April is "Last Month Sales", in your description you mentioned a top 10 but I don't see any top 10 in your table or any of the objects, if you could be more clear into what is not working we might be able to provide better assistance. or is the issue at backend level ?

Re: Sales By Month

pratap6699 — Thu, 11 Jun 2015 20:09:47 GMT

aggr(if(Rank(sum(sales)<=10,branch1),branch1

aggr(if(Rank(sum(sales)<=10,branch2),branch2