Set analysis alternatives?

[#1]

Hi there

How would I apply set analysis to the following expression to stop it being affected by other selections on qlik sense by the user?

Also, are there alternatives to set analysis?

Regards,

[Chanty4u]

there is no exp ..but chk dis

Excluding values in Set Analysis

[#3]

=count(distinct if(aggr(sum([EY_AMT]),[JE Num])>0, [JE Num])) & ' journal(s) unbalanced: ' & concat(distinct if(aggr(sum([EY_AMT]),[JE Num])>0, [JE Num]) & ' ')

Apologies. Thanks for the link I will look at it now

[sunny_talwar · Accepted solution]

May be this:

=Count({1}Distinct if(Aggr(Sum({1} [EY_AMT]), [JE Num])>0, [JE Num])) & ' journal(s) unbalanced: ' & Concat({1}Distinct If(Aggr(Sum({1} [EY_AMT]),[JE Num])>0, [JE Num]) & ' ')