topic Re: Column() function in QlikView https://community.qlik.com/t5/QlikView/Column-function/m-p/582056#M1115780 <HTML><HEAD></HEAD><BODY><P>Thank you for your help!</P></BODY></HTML> Thu, 27 Feb 2014 23:23:17 GMT 2014-02-27T23:23:17Z Column() function https://community.qlik.com/t5/QlikView/Column-function/m-p/582054#M1115778 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>how can I write an expression with column function to filter my date where columns n. 1, n. 5 and n. 9 aren't zero?</P><P>I could use a conditional expression like this:</P><P><SPAN style="font-size: 10pt;"> <SPAN style="color: #0000ff;">If</SPAN>(<SPAN style="color: #0000ff;">column</SPAN>(1) = 0, <SPAN style="color: #0000ff;">If</SPAN>(<SPAN style="color: #0000ff;">column</SPAN>(5) = 0, <SPAN style="color: #0000ff;">If</SPAN>(<SPAN style="color: #0000ff;">column</SPAN>(9) = 0, 0, expression), expression), expression)</SPAN></P><P><SPAN style="font-size: 10pt;">or there is another better way to write it?</SPAN></P><P>Thanks in advance for your answers.</P><P>Andrea</P></BODY></HTML> Thu, 27 Feb 2014 22:35:14 GMT https://community.qlik.com/t5/QlikView/Column-function/m-p/582054#M1115778 2014-02-27T22:35:14Z Re: Column() function https://community.qlik.com/t5/QlikView/Column-function/m-p/582055#M1115779 <HTML><HEAD></HEAD><BODY><P>You can probably use 1 if to check if the sum of those columns is 0 (using sum or rangesum)</P></BODY></HTML> Thu, 27 Feb 2014 22:42:08 GMT https://community.qlik.com/t5/QlikView/Column-function/m-p/582055#M1115779 2014-02-27T22:42:08Z Re: Column() function https://community.qlik.com/t5/QlikView/Column-function/m-p/582056#M1115780 <HTML><HEAD></HEAD><BODY><P>Thank you for your help!</P></BODY></HTML> Thu, 27 Feb 2014 23:23:17 GMT https://community.qlik.com/t5/QlikView/Column-function/m-p/582056#M1115780 2014-02-27T23:23:17Z Re: Column() function https://community.qlik.com/t5/QlikView/Column-function/m-p/582057#M1115781 <HTML><HEAD></HEAD><BODY><P>You're welcome! Happy QlikViewing!</P></BODY></HTML> Fri, 28 Feb 2014 13:08:45 GMT https://community.qlik.com/t5/QlikView/Column-function/m-p/582057#M1115781 2014-02-28T13:08:45Z