topic Re: Less number of rows after exporting to excel in QlikView https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206820#M877759 <HTML><HEAD></HEAD><BODY><P>it is happening in Straight Table as well</P></BODY></HTML> Wed, 19 Oct 2016 21:08:02 GMT 2016-10-19T21:08:02Z Less number of rows after exporting to excel https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206818#M877757 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am getting less number of rows in table box in Qlikview however the count of rows in table is showing correct in Qlikview Data model</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206818#M877757 2020-11-25T16:16:04Z Re: Less number of rows after exporting to excel https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206819#M877758 <HTML><HEAD></HEAD><BODY><P>A table box only shows distinct combination of column values, not duplicate rows.</P></BODY></HTML> Wed, 19 Oct 2016 21:04:01 GMT https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206819#M877758 swuehl 2016-10-19T21:04:01Z Re: Less number of rows after exporting to excel https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206820#M877759 <HTML><HEAD></HEAD><BODY><P>it is happening in Straight Table as well</P></BODY></HTML> Wed, 19 Oct 2016 21:08:02 GMT https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206820#M877759 2016-10-19T21:08:02Z Re: Less number of rows after exporting to excel https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206821#M877760 <HTML><HEAD></HEAD><BODY><P>Could you post some more details what you exactely you are comparing in QV vs. Excel?</P></BODY></HTML> Wed, 19 Oct 2016 21:46:33 GMT https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206821#M877760 swuehl 2016-10-19T21:46:33Z Re: Less number of rows after exporting to excel https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206822#M877761 <HTML><HEAD></HEAD><BODY><P>QV will only display distinct records in the table objects (including in Pivot and Straight tables).</P><P>If you want to be sure, you may include a "counter" field into your load, such as <STRONG>RecNo()</STRONG> or <STRONG>RowNo()</STRONG>. This will ensure that you have a unique record-level field to display in your Tablebox.</P><P></P><P>S.</P></BODY></HTML> Wed, 19 Oct 2016 22:48:34 GMT https://community.qlik.com/t5/QlikView/Less-number-of-rows-after-exporting-to-excel/m-p/1206822#M877761 shawn-qv 2016-10-19T22:48:34Z