Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
JMAROUF
Creator
Creator

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

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