topic How to use set analysis in qlikview? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-set-analysis-in-qlikview/m-p/463441#M173060 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>How to use set analysis in qlikview,</P><P>how to define this fourmula into set analysis</P><P>if(sum(Access)&gt;=1000000,</P><P></P><P>num(sum(Access)/1000000,'#,##0.0 M'),</P><P></P><P>num(sum(Access)/1000,'#,##0 K')</P><P>please help me above that.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 12 Jun 2013 08:12:51 GMT 2013-06-12T08:12:51Z How to use set analysis in qlikview? https://community.qlik.com/t5/QlikView/How-to-use-set-analysis-in-qlikview/m-p/463441#M173060 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>How to use set analysis in qlikview,</P><P>how to define this fourmula into set analysis</P><P>if(sum(Access)&gt;=1000000,</P><P></P><P>num(sum(Access)/1000000,'#,##0.0 M'),</P><P></P><P>num(sum(Access)/1000,'#,##0 K')</P><P>please help me above that.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 12 Jun 2013 08:12:51 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-analysis-in-qlikview/m-p/463441#M173060 2013-06-12T08:12:51Z Re: How to use set analysis in qlikview? https://community.qlik.com/t5/QlikView/How-to-use-set-analysis-in-qlikview/m-p/463442#M173061 <HTML><HEAD></HEAD><BODY><P>That cannot be done with a set analysis expression. Your if statement is the correct solution.</P></BODY></HTML> Wed, 12 Jun 2013 09:38:47 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-analysis-in-qlikview/m-p/463442#M173061 Gysbert_Wassenaar 2013-06-12T09:38:47Z