https://community.qlik.com/t5/Integration-Extension-APIs/Get-a-subset-of-field-given-a-condition/m-p/1551211#M10098 <P>Hi everyone,</P><P>we are trying to use SSE extension to integrate Python in QlikSense. Imagine the following situation:</P><TABLE><TBODY><TR><TD>Field A</TD><TD>Field B</TD><TD>if(match(A,1),A)</TD></TR><TR><TD>1</TD><TD>3</TD><TD>1</TD></TR><TR><TD>5</TD><TD>9</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>2</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>We would like to export only the first row which has&nbsp;a value. At the moment, we were able to export the third column but we end up with NaN for missing values.</P> Fri, 01 Mar 2019 16:43:02 GMT bsalmeri 2019-03-01T16:43:02Z https://community.qlik.com/t5/Integration-Extension-APIs/Get-a-subset-of-field-given-a-condition/m-p/1551211#M10098 <P>Hi everyone,</P><P>we are trying to use SSE extension to integrate Python in QlikSense. Imagine the following situation:</P><TABLE><TBODY><TR><TD>Field A</TD><TD>Field B</TD><TD>if(match(A,1),A)</TD></TR><TR><TD>1</TD><TD>3</TD><TD>1</TD></TR><TR><TD>5</TD><TD>9</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>2</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>We would like to export only the first row which has&nbsp;a value. At the moment, we were able to export the third column but we end up with NaN for missing values.</P> Fri, 01 Mar 2019 16:43:02 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Get-a-subset-of-field-given-a-condition/m-p/1551211#M10098 bsalmeri 2019-03-01T16:43:02Z