How to use set analysis in qlikview?

[#1]

Hi Team,

How to use set analysis in qlikview,

how to define this fourmula into set analysis

if(sum(Access)>=1000000,

num(sum(Access)/1000000,'#,##0.0 M'),

num(sum(Access)/1000,'#,##0 K')

please help me above that.

Thanks

[Gysbert_Wassenaar]

That cannot be done with a set analysis expression. Your if statement is the correct solution.