topic Re: Not showing all data in QlikView

Not showing all data

abisson1 — Mon, 14 Sep 2015 20:28:35 GMT

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

Re: Not showing all data

Ralf-Narfeldt — Tue, 15 Sep 2015 09:06:51 GMT

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.

Re: Not showing all data

jsingh71 — Tue, 15 Sep 2015 09:43:49 GMT

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

Re: Not showing all data

sasiparupudi1 — Tue, 15 Sep 2015 10:13:02 GMT

use a preceding load

[Sheet]:

load *,RecNo() as UniqueID;

Load [Serial number],

[Pcb number],

...

From your excel file;

hth

Sasi

Re: Not showing all data

abisson1 — Wed, 16 Sep 2015 19:31:36 GMT

Thank you all, it work find.