topic Distinct without Sum or Count in QlikView

Distinct without Sum or Count

psk180590 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I'm looking to find out if there is any possibility to get Distinct of a Column and Store it as Another Column without using any aggregation Values such as Sum or Count.

Say i have the following ID's:

ID
FB1
FB2
FB1
FB6
FB7
FB8
FB5
FB4
FB6
FB9
FB3

I need to generate another Column at the Script level using Distinct of this values:

Distinct ID
FB1
FB2
FB6
FB7
FB8
FB5
FB4
FB9
FB3

Thanks.

Sai

Re: Distinct without Sum or Count

teiswamsler — Mon, 04 Dec 2017 10:15:46 GMT

hi Pakalapati

Try this

Table2:

Load distinct

ID as "Distinct ID"

Resident Table 1;

/Teis

Re: Distinct without Sum or Count

Akina0929 — Mon, 04 Dec 2017 10:30:25 GMT

Hi sai kumar,

use first value function in script.

load

firstvalue(id) as id

from..........

thanks