topic Re: Row count is increasing like crazy in QlikView https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672920#M244394 <HTML><HEAD></HEAD><BODY><P>Show the Table Viewer screenshot here...</P></BODY></HTML> Thu, 11 Sep 2014 08:06:03 GMT MK_QSL 2014-09-11T08:06:03Z Row count is increasing like crazy https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672917#M244391 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I have one qvd i am getting 700000 row count when i run that qvd alone.</P><P></P><P>when i included that in the Data Model, the row count is going like anything, it is going till 50000000, like that.</P><P></P><P>Any suggestion what would be the reason.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 11 Sep 2014 06:20:59 GMT https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672917#M244391 2014-09-11T06:20:59Z Re: Row count is increasing like crazy https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672918#M244392 <HTML><HEAD></HEAD><BODY><P>Cartesian Product. One of ur join statement is the issue. Try reloading table by table. u can sort out the issue.</P><P>-Sundar</P></BODY></HTML> Thu, 11 Sep 2014 06:25:14 GMT https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672918#M244392 sundarakumar 2014-09-11T06:25:14Z Re: Row count is increasing like crazy https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672919#M244393 <HTML><HEAD></HEAD><BODY><P>It seems like the Key on which you are joining it with Data Model is not just enough to uniquely represent a row.</P><P></P><P>I believe, the rows are getting multiplied due to duplicates in it.</P><P></P><P>to verify this, create a list box of the Key field and check its frequency.</P><P></P><P>Use AutonumberHash256(Field1,Field2,Field3) as FinalKey</P><P></P><P></P><P></P><P>Thanks,</P><P>Angad</P></BODY></HTML> Thu, 11 Sep 2014 06:32:19 GMT https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672919#M244393 2014-09-11T06:32:19Z Re: Row count is increasing like crazy https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672920#M244394 <HTML><HEAD></HEAD><BODY><P>Show the Table Viewer screenshot here...</P></BODY></HTML> Thu, 11 Sep 2014 08:06:03 GMT https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672920#M244394 MK_QSL 2014-09-11T08:06:03Z Re: Row count is increasing like crazy https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672921#M244395 <HTML><HEAD></HEAD><BODY><P>Please check your Keys, the Key may not be matching so its replicating against every Key</P></BODY></HTML> Thu, 11 Sep 2014 08:10:52 GMT https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672921#M244395 nam 2014-09-11T08:10:52Z Re: Row count is increasing like crazy https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672922#M244396 <HTML><HEAD></HEAD><BODY><P>May be you have any cross joins.</P><P></P><P>If possible place script and datamodel</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 11 Sep 2014 08:12:03 GMT https://community.qlik.com/t5/QlikView/Row-count-is-increasing-like-crazy/m-p/672922#M244396 ashfaq_haseeb 2014-09-11T08:12:03Z