topic Re: Help in set analysis in QlikView https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083540#M360860 <HTML><HEAD></HEAD><BODY><P>=if(status='Active',1,0)</P><P></P><P>HTH</P><P></P><P>Vikas</P></BODY></HTML> Wed, 16 Mar 2016 06:55:15 GMT vikasmahajan 2016-03-16T06:55:15Z Help in set analysis https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083536#M360856 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have calculated dimension as below</P><P></P><P>=if(match(status='Active',status)</P><P></P><P>How can I write the same in set analysis?</P></BODY></HTML> Wed, 16 Mar 2016 06:49:42 GMT https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083536#M360856 2016-03-16T06:49:42Z Re: Help in set analysis https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083537#M360857 <HTML><HEAD></HEAD><BODY><P><EM>Instead of using calculated dimension use set analysis in expression like below</EM></P><P></P><P><EM>=sum({&lt;status={'Active'}&gt;}Value)</EM></P></BODY></HTML> Wed, 16 Mar 2016 06:51:01 GMT https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083537#M360857 Kushal_Chawda 2016-03-16T06:51:01Z Re: Help in set analysis https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083538#M360858 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Add dimension as status and set expression as Only({&lt;status={'Active'}&gt;}</SPAN><SPAN style="font-size: 13.3333px;">status)</SPAN></P></BODY></HTML> Wed, 16 Mar 2016 06:51:29 GMT https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083538#M360858 tamilarasu 2016-03-16T06:51:29Z Re: Help in set analysis https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083539#M360859 <HTML><HEAD></HEAD><BODY><P>use only function</P></BODY></HTML> Wed, 16 Mar 2016 06:54:34 GMT https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083539#M360859 Chanty4u 2016-03-16T06:54:34Z Re: Help in set analysis https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083540#M360860 <HTML><HEAD></HEAD><BODY><P>=if(status='Active',1,0)</P><P></P><P>HTH</P><P></P><P>Vikas</P></BODY></HTML> Wed, 16 Mar 2016 06:55:15 GMT https://community.qlik.com/t5/QlikView/Help-in-set-analysis/m-p/1083540#M360860 vikasmahajan 2016-03-16T06:55:15Z