Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Valued Contributor II

Cross Tables Duplicates Removal

HI all,

i made a cross table in Which i have combine 6 column into one field which is my AGeing column.. now my Ageing values Frequency is increased.. how can i remove Duplicates from them.

regards

Abhay

3 Replies
Highlighted
Not applicable

Re: Cross Tables Duplicates Removal

try This:

use Distinct to remove duplicates

ex:

Tablename:

LOAD  Distinct 

     oneField

FROM

[..\QVD\Raw QVD\Tablename.qvd]

(qvd);

Highlighted

Re: Cross Tables Duplicates Removal

May be try a resident load from your previous table and use a group by statement with the FirstValue function which will give you the first instance of the repetition.

Best,

Sunny

Highlighted
Contributor III

Re: Cross Tables Duplicates Removal

hi,

you must add a DISTINCT just after your LOAD, so that you load only different lines