Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
As per your excel, last three records are identical. that is the reason its showing only 2 records.
use a preceding load
[Sheet]:
load *,RecNo() as UniqueID;
Load [Serial number],
[Pcb number],
...
..
From your excel file;
hth
Sasi
Thank you all, it work find.