topic Set analisys filter records in QlikView https://community.qlik.com/t5/QlikView/Set-analisys-filter-records/m-p/517360#M193155 <HTML><HEAD></HEAD><BODY><P>Hi! I have this data load in the app</P><P></P><P>id&nbsp;&nbsp;&nbsp; field1&nbsp;&nbsp;&nbsp; field2 </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data1</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data2</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data1</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data2</P><P></P><P>I need, in set analysis, when field2 is value "data2" EXCLUDE the registers for id = 1</P><P></P><P></P><P>Thamks a lot! And sorry for my english!!!</P></BODY></HTML> Wed, 15 Jan 2014 18:22:01 GMT 2014-01-15T18:22:01Z Set analisys filter records https://community.qlik.com/t5/QlikView/Set-analisys-filter-records/m-p/517360#M193155 <HTML><HEAD></HEAD><BODY><P>Hi! I have this data load in the app</P><P></P><P>id&nbsp;&nbsp;&nbsp; field1&nbsp;&nbsp;&nbsp; field2 </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data1</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data2</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data1</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data2</P><P></P><P>I need, in set analysis, when field2 is value "data2" EXCLUDE the registers for id = 1</P><P></P><P></P><P>Thamks a lot! And sorry for my english!!!</P></BODY></HTML> Wed, 15 Jan 2014 18:22:01 GMT https://community.qlik.com/t5/QlikView/Set-analisys-filter-records/m-p/517360#M193155 2014-01-15T18:22:01Z Re: Set analisys filter records https://community.qlik.com/t5/QlikView/Set-analisys-filter-records/m-p/517361#M193156 <HTML><HEAD></HEAD><BODY><P>Not sure what you're trying to show. But try <EM>only({&lt;id-={1},field2={'data2'}&gt;}field2)</EM> as expression.</P><P>btw, the expression editor doesn't recognize -= as valid syntax and will show a red underlining indicating an error, but it is actually correct.</P></BODY></HTML> Wed, 15 Jan 2014 18:22:54 GMT https://community.qlik.com/t5/QlikView/Set-analisys-filter-records/m-p/517361#M193156 Gysbert_Wassenaar 2014-01-15T18:22:54Z