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: 
JMAROUF
Creator II
Creator II

set analysis

Hi everyone,

i want to sum sales of salers whose sales are equal to 10367007,4265, i have tried this:

=sum({1 <SalesPersonID={"=sum(SubTotal) =10367007,4265"}>} SubTotal) 

but it doesn't work, 

my goal is to understand advanced set analysis, can any one help please?

PS: it's possible with p() function? 

Best regards.

Labels (2)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

It could be the decimal separator that is the issue.

Try changing  from comma to dot for your comparison number, like this: 10367007.4265

View solution in original post

4 Replies
Saravanan_Desingh

Try this,

=sum({<SalesPersonID={"=Match(sum(SubTotal),10367007,4265)"}>} SubTotal) 
Denisg
Contributor III
Contributor III

Hi,
Or this one:
=Sum({<[SalesPersonID]={"=Sum(Distinct SubTotal)=10367007,4265"}>} SubTotal)

Vegar
MVP
MVP

It could be the decimal separator that is the issue.

Try changing  from comma to dot for your comparison number, like this: 10367007.4265

JMAROUF
Creator II
Creator II
Author

@Saravanan_Desingh , @Denisg ,

thank you for the reply, the the both solutions didn't work. here is my model, any help plezase.

JMAROUF_0-1615715277934.png