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: 
bwisealiahmad
Partner - Specialist
Partner - Specialist

Nested SET Analysis with Larger or Less Than

Hi,

I am trying to write a Nested SET Analysis Expression.

I want to Count the ClientNo's where the sum of account numbers connected to that ClientNr is larger than 0.

I have tried with:

Count(Distinct {<

ClientNo =

{"

Sum({<AccountNumber = P({<FactType= {'Accounting'}, AccountNumber= {">=2800<=29899"}>})>}Amount)

>  0

"}

>}ClientNo)

The issue seems like it is that there are two " " inside of the nested part.

Any suggestions?

Best,

Ali A

1 Reply
Chanty4u
MVP
MVP

try this


Count({<ClientNo ={"=

Sum({<AccountNumber = P({<FactType= {'Accounting'}, AccountNumber= {">=2800<=29899"}>})>}Amount)>=0"}>}distinct ClientNo)

or

Count({<ClientNo ={"=

Sum({<AccountNumber = P({<FactType= {'Accounting'}, AccountNumber= {">=2800<=29899"}>})>}Amount)>0"}>}distinct ClientNo)