topic Re: Dissapeared rows in a plane table in QlikView

Dissapeared rows in a plane table

Wed, 29 Oct 2014 10:40:43 GMT

according to the table viewr I have a table with 96.162 rows.

In order to make some verifications I made a table box with all the fields but it has only 85.785 rows.

I think the reason is that there are some rows with all its fields equals so it shows them only once.

How could avoid this so I can take to excel 96.162 rows using the table box?

Thanks

Re: Dissapeared rows in a plane table

anbu1984 — Wed, 29 Oct 2014 10:44:20 GMT

Add RowNo()

Load *,RowNo() From Table

Re: Dissapeared rows in a plane table

rubenmarin — Wed, 29 Oct 2014 10:44:33 GMT

Hi Luis,

In script, when you are creating the table, you can create a field like RowNo() as FileID, adding this field to the table box will make all records different.

Re: Dissapeared rows in a plane table

its_anandrjs — Wed, 29 Oct 2014 10:49:20 GMT

Hi,

May be there is some fields are same and due to that it is display only 85785 for check add another field ROWNO() in the load script

Ex:-

Load

RowNo() As Rowid,

....

From Location;

Regards

Anand

Re: Dissapeared rows in a plane table

Wed, 29 Oct 2014 10:52:13 GMT

But I do not understand why I need to do so if the table is all right in memory with its 96.162 rows. Is the object 'Table Box...' which is not showing all the rows.

Does not exist a parametrer to say it 'show all'?

thanks

Re: Dissapeared rows in a plane table

ashfaq_haseeb — Wed, 29 Oct 2014 10:54:52 GMT

May be few of your records are repeated.

That's the reason you need to add Rowno() Function.

Check this blog for better understanding.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno

Regards

ASHFAQ

Re: Dissapeared rows in a plane table

anbu1984 — Wed, 29 Oct 2014 10:57:59 GMT

Check this example

Re: Dissapeared rows in a plane table

Colin-Albert — Wed, 29 Oct 2014 11:00:34 GMT

The table box only displays the unique values in the selected fields.

If there are any duplicate rows, then the data is only displayed once.

To view all rows, there must be a unique field on each row displayed in the table box.