topic Re: Distinct result on dimension in QlikView

Distinct result on dimension

rakeshkumar1890 — Thu, 10 Dec 2020 06:24:47 GMT

Hello everyone,

I am trying to get distinct result but as below result:

Table :

Id	discription
100	abd
100	abd
100
200	uyt
200
200
300
300

Result:

Id	discription
100	abd
200	uyt
300

Need this result on table dimension.

Thanks to everyone.

Re: Distinct result on dimension

pradosh_thakur — Thu, 10 Dec 2020 07:24:30 GMT

Try this

load Id, SubField(discription,',') as discription;
load Id, concat(distinct if(len(trim(discription))>0,discription),',') as discription
group by Id
;
load * inline [
Id,discription
100,abd
100,abd1
100,
200,uyt
200
200
300
300
];

Re: Distinct result on dimension

rakeshkumar1890 — Thu, 10 Dec 2020 07:58:06 GMT

Thanks @pradosh_thakur for idea but I need this on expression not an script.

Re: Distinct result on dimension

Chanty4u — Thu, 10 Dec 2020 09:32:31 GMT

try this

=only(AGGR(SUM(DISTINCT Id),discription))

Re: Distinct result on dimension

rakeshkumar1890 — Thu, 10 Dec 2020 10:49:31 GMT

Thanks @Chanty4u , Its not working

Re: Distinct result on dimension

Taoufiq_Zarra — Thu, 10 Dec 2020 11:01:45 GMT

@rakeshkumar1890

dimension : ID

Measure : =concat(distinct discription,'')

output:

Re: Distinct result on dimension

gp_oconnor — Thu, 10 Dec 2020 11:03:59 GMT

First dimension in table: Id

Second dimension in table: =Aggr(MaxString([discription]),Id)