Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sales By Month

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

Labels (1)
12 Replies
Not applicable
Author

HI Dass

Yes

In the Script there is  the restriction

ramoncova06
Partner - Specialist III
Partner - Specialist III

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 ?

pratap6699
Creator
Creator

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

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