topic Transform if into set analysis in QlikView https://community.qlik.com/t5/QlikView/Transform-if-into-set-analysis/m-p/240306#M90844 <HTML><HEAD></HEAD><BODY><P></P><P>Is it possible to solve this with a set?</P><P></P><P>=sum(if(Dos_HoofdId &lt;&gt; Dos_Id,1,0))</P><P></P><P>tnx</P></BODY></HTML> Wed, 17 Feb 2010 13:16:30 GMT timmy 2010-02-17T13:16:30Z Transform if into set analysis https://community.qlik.com/t5/QlikView/Transform-if-into-set-analysis/m-p/240306#M90844 <HTML><HEAD></HEAD><BODY><P></P><P>Is it possible to solve this with a set?</P><P></P><P>=sum(if(Dos_HoofdId &lt;&gt; Dos_Id,1,0))</P><P></P><P>tnx</P></BODY></HTML> Wed, 17 Feb 2010 13:16:30 GMT https://community.qlik.com/t5/QlikView/Transform-if-into-set-analysis/m-p/240306#M90844 timmy 2010-02-17T13:16:30Z Transform if into set analysis https://community.qlik.com/t5/QlikView/Transform-if-into-set-analysis/m-p/240307#M90845 <HTML><HEAD></HEAD><BODY><P>what do you want to reach? if you need to count rows/records where Dos_Hoofdld not equal to Dos_Id, then you can use count function in field, where always will be a value</P><P>AT</P></BODY></HTML> Wed, 17 Feb 2010 13:37:42 GMT https://community.qlik.com/t5/QlikView/Transform-if-into-set-analysis/m-p/240307#M90845 Anonymous 2010-02-17T13:37:42Z Transform if into set analysis https://community.qlik.com/t5/QlikView/Transform-if-into-set-analysis/m-p/240308#M90846 <HTML><HEAD></HEAD><BODY><P>Timmy, we need more info, you could add your statement in the script and then sum the fields, or possibly use the exists function. With the info provided the If function would do the job you do not always have to use sets.</P><P>What is the expression in relation to?</P><P>regards,</P><P>Neil</P></BODY></HTML> Wed, 17 Feb 2010 14:00:12 GMT https://community.qlik.com/t5/QlikView/Transform-if-into-set-analysis/m-p/240308#M90846 2010-02-17T14:00:12Z