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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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