Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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]) & ' ')
there is no exp ..but chk dis
=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
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]) & ' ')