topic ColumnNo() in QlikView https://community.qlik.com/t5/QlikView/ColumnNo/m-p/360385#M578842 <HTML><HEAD></HEAD><BODY><P>Anyone know how to get column number (expressions) in straight tables?</P><P></P><P>From the Help file: the <SPAN style="color: #ffffff; background-color: #3399ff;">ColumnNo</SPAN> and <SPAN class="Bold">NoOfColumns</SPAN> functions are relevant only to pivot tables. </P></BODY></HTML> Tue, 20 Mar 2012 15:59:09 GMT Anonymous 2012-03-20T15:59:09Z ColumnNo() https://community.qlik.com/t5/QlikView/ColumnNo/m-p/360385#M578842 <HTML><HEAD></HEAD><BODY><P>Anyone know how to get column number (expressions) in straight tables?</P><P></P><P>From the Help file: the <SPAN style="color: #ffffff; background-color: #3399ff;">ColumnNo</SPAN> and <SPAN class="Bold">NoOfColumns</SPAN> functions are relevant only to pivot tables. </P></BODY></HTML> Tue, 20 Mar 2012 15:59:09 GMT https://community.qlik.com/t5/QlikView/ColumnNo/m-p/360385#M578842 Anonymous 2012-03-20T15:59:09Z ColumnNo() https://community.qlik.com/t5/QlikView/ColumnNo/m-p/360386#M578843 <HTML><HEAD></HEAD><BODY><P>That would depend on the number for expressions. I believe columnNo only works on pivot because you can move a dimension to run left to right so there is no set column number. </P></BODY></HTML> Tue, 20 Mar 2012 16:12:22 GMT https://community.qlik.com/t5/QlikView/ColumnNo/m-p/360386#M578843 2012-03-20T16:12:22Z