Discussion Board for collaboration related to QlikView App Development.
I have one qvd i am getting 700000 row count when i run that qvd alone.
when i included that in the Data Model, the row count is going like anything, it is going till 50000000, like that.
Any suggestion what would be the reason.
Go to Solution.
It seems like the Key on which you are joining it with Data Model is not just enough to uniquely represent a row.
I believe, the rows are getting multiplied due to duplicates in it.
to verify this, create a list box of the Key field and check its frequency.
Use AutonumberHash256(Field1,Field2,Field3) as FinalKey
Cartesian Product. One of ur join statement is the issue. Try reloading table by table. u can sort out the issue.
Show the Table Viewer screenshot here...
Please check your Keys, the Key may not be matching so its replicating against every Key
May be you have any cross joins.
If possible place script and datamodel