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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression

Hi Experts

I have an expression for MTD sales

Sum({< MonthYear=, Date = {'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'} >} Sales)

and I want to choose top 5 customers for each branch

SUM({<Customer = {"=Rank(SUM(Sales),4)<=5"}>}Sales)

How  can i combine these two expressions together

Please Help

13 Replies
Kushal_Chawda

Can you paste your output here which you needed?

Not applicable
Author

HI Kush

Here is the QVW attached

Expected each Branch by customer top 5 sales

Not applicable
Author

HI this is the expected output

Capture.JPGExpected each Branch by customer top 5 sales

Kushal_Chawda

see the attached