topic Re: Rowno() in pivot table in QlikView https://community.qlik.com/t5/QlikView/Rowno-in-pivot-table/m-p/817267#M288152 <HTML><HEAD></HEAD><BODY><P>The rowno() is calculated for the lowest level shown. If you expand only certain values of a dimension then the rowno() will be shown for these expanded rows. And the rowno cannot be displayed for the collapsed dimension values.</P></BODY></HTML> Fri, 14 Nov 2014 14:18:47 GMT Gysbert_Wassenaar 2014-11-14T14:18:47Z Rowno() in pivot table https://community.qlik.com/t5/QlikView/Rowno-in-pivot-table/m-p/817266#M288151 <HTML><HEAD></HEAD><BODY><P>i need mod of row number for each row in pivot table.</P><P>i use in expression as --&nbsp; <STRONG>mod(rowno(total),2)</STRONG></P><P></P><P>nut its behaviour changes when i do drill down&nbsp; and no value is shown</P><P></P><P><IMG __jive_id="71065" alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/71065_pastedImage_1.png" style="width: auto; height: auto;" /></P><P></P><P></P><P>please help me out</P></BODY></HTML> Wed, 12 Nov 2014 11:00:15 GMT https://community.qlik.com/t5/QlikView/Rowno-in-pivot-table/m-p/817266#M288151 2014-11-12T11:00:15Z Re: Rowno() in pivot table https://community.qlik.com/t5/QlikView/Rowno-in-pivot-table/m-p/817267#M288152 <HTML><HEAD></HEAD><BODY><P>The rowno() is calculated for the lowest level shown. If you expand only certain values of a dimension then the rowno() will be shown for these expanded rows. And the rowno cannot be displayed for the collapsed dimension values.</P></BODY></HTML> Fri, 14 Nov 2014 14:18:47 GMT https://community.qlik.com/t5/QlikView/Rowno-in-pivot-table/m-p/817267#M288152 Gysbert_Wassenaar 2014-11-14T14:18:47Z