Not showing all data

[abisson1]

Hello,

First off all, I'm new using clik, so this question may appear trivial but I'm stuck.

How can I make sure all the data will appear in a table. By example from the source file (excel file) I should see 4 result while in qlik it only show 2 line eventhoug it tell me there' should be 4.

It appear that qlik will not show multiple line having the same date.

What Am I doing wrong? I'm not using Distinct for date..

Thanks in advance.

Andre

[Ralf-Narfeldt]

100% identical rows will only be shown once.

You could add an ID field unique for each line, like RecNo() As ID in the load.

[jsingh71]

As per your excel, last three records are identical. that is the reason its showing only 2 records.

[sasiparupudi1]

use a preceding load

[Sheet]:

load *,RecNo() as UniqueID;

Load [Serial number],

[Pcb number],

...

..

From your excel file;

hth

Sasi

[abisson1]

Thank you all, it work find.