topic Re: Remove double data by date in QlikView

Remove double data by date

Tue, 16 Feb 2016 13:17:57 GMT

Dear all,

As a beginner working with Qlikview, I have started combining 2 Excel sheets into my first project.

One of the columns in the sheets contains double data, because in the specific rows a different date of entry is entered.

I would like to filter out this excess data in Qlikview, not in Excel.

It should be something like:

Count (data)

But skip the second appearance of the same data in the calculation.

Any suggestions?

Thanks in advance!

maxgro — Tue, 16 Feb 2016 21:46:52 GMT

If I understand the question, you can load your excel data (replace the inline load with load from excel)

Source:

load * inline [

f1, f2, f3

1, a, 11

2, b, 22

3, c, 33

4, a, 44

];

and then remove the duplicated (f2 field) rows using peek

here I only keep the first 'a' in f2 field and the first 'b, first 'c', etc.....

Final:

NoConcatenate load *

Resident Source

where Peek('f2') <> f2

order by f2, f1;

DROP Table Source;