Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional aggr expression

Hello guys,

I am trying to do a conditional aggr function but failing.

I am trying to filter on salesman_id to find out what days he has worked.

I then wan to calculate the total sales by all salesman for that day.

e.g. in the attached spreadsheet, salesman Id 2005 has worked days 1,4,7,9 etc

I remove the filter from salesman ID and put the filter on day 1.

I then get the total of List Price for day one which is 90483.

I am struggling to put this in my expression, please help

thanks

11 Replies
swuehl
MVP
MVP

You're welcome.

Please note that my expression will only take days into account, where sum([List Price]) per Salesman ID is larger than zero. If your Salesman do work without resulting in revenue / [List Price] value, this will not work.

Not applicable
Author

Thanks for the tip Stefan.

I should be OK as I don't have null or - values.

thanks