Iam loading data in to qlikview from excel file which contains lakhs of data after taking that one in to straight table and iam sending that data in to excel file from staright table it is showing only 8000 records .

[#1]

can any one please say the reason for this. iam using persional edition

[Anonymous]

Hi,

In Straight table records are displayed based on dimensions selected and aggregations used.

select all dimensions and do only basic aggregations and check count of records.

if still find an issue,goto table viewer and check  for no of records by hovering on tables and

compare if any discrepancies.

Regards

Neetha

[PrashantSangle]

Hi,

Try like load all field as dimension and in expression tab add expression as 1

Do not check supress value as null.

Regards

[#4]

Based on my point 2 above and Neetha's reply - can you bring all fields into a simple table box and export to see how many rows are there.... if that hangs up your system - then an alternative is to find the most granular field and use only that field in table box to export.

The blank rows shouldn't matter to QlikView.

Alternatively, can you check if your totals are still right - like sum(revenue) or sum(sales) or count(transactions)

[#5]

Hi neeta plz tell me how to check the count in straight table

[Peter_Cammaert]

There may be a simple approach to keeping your data intact when importing/exporting Excel rows.

Try this:

• In your Excel LOAD statement, add a RowNo() field.
• In your straight table, add all individual Excel fields as dimensions, including the RowNo field
• Add a single expression to your straight table, for example =1.
• In Straight Table->Properties->Presentation, hide both the RowNo column and the expression column.
• Export and check the result.

Good luck,

Peter

[#7]

In the Table Viewer (Ctrl T), if you mouseover the table name, it will show number of records - what is that showing up as? Is it matching the number of rows you are expecting to load?

[Anonymous]

Hi,

script to create sequence of numbers for records with RowNo() Function:

Data1:

LOAD Customer,

     [Sales Order ID],

     ShipDate,

     Product,

     Sales,

     Quantity

FROM

(biff, embedded labels);

Data:

LOAD *,

RowNo() as NoOfRecords

Resident Data1;

In Addition to Peter's suggestions you can also test by using below expression in text Object

=Max(NoOfRecords)

which gives count of records.

Make sure you are not using where clause in script while checking these scenario.

Regards

Neetha

[#9]

Hi rgv ,

if possible can u share that xl file