Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Row count is increasing like crazy

Hello Everyone,

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.

Thanks

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Row count is increasing like crazy

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

Thanks,

Angad

5 Replies
sundarakumar
Valued Contributor II

Re: Row count is increasing like crazy

Cartesian Product. One of ur join statement is the issue. Try reloading table by table. u can sort out the issue.

-Sundar

Not applicable

Re: Row count is increasing like crazy

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

Thanks,

Angad

MVP
MVP

Re: Row count is increasing like crazy

Show the Table Viewer screenshot here...

Highlighted
Employee
Employee

Re: Row count is increasing like crazy

Please check your Keys, the Key may not be matching so its replicating against every Key

Re: Row count is increasing like crazy

May be you have any cross joins.

If possible place script and datamodel

Regards

ASHFAQ