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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

PLS EXPLAIN ABOUT THIS EXPRESSION? ................

PLS EXPLAIN ABOUT THIS EXPRESSION? ................

IF(AGGR(RANK(SUM(SALES)),CUSTOMER,SALESPERSON=1,SALESPERSON)                 AND

IF(AGGR(SUM(SALES)),CUSTOMER,SALESPERSON)                         AND

IF(AGGR(SUM(SALES)),CUSTOMER)   <=2,CUSTOMER)

Please explain me about these three expresions      PLs...............................................................

I AM GREATFUL TO U

2 Replies
Not applicable
Author

if the sales done by the salesperson is ranked the first when grouped by customer and salesperson

and...

the third says

if the sales for a customer ranks in the top 2 display the customer

Your second if condition looks incomplete.

Not applicable
Author

Hi

The Expression is wrong

Are you getting any result for this expression??