topic Aggr function combination in QlikView

Aggr function combination

Tue, 10 Dec 2013 08:23:33 GMT

Hi All,

I need to fill req. as below.

If i have ID(unique) with respect to unique LSR then i have to capture only one record count whether 1 or 0 and if i have disinct ID's with unique LSR then i have to count both id's.

Id No LSR Count(expected)

750485 165 3245002 0(whether 0 or 1)

750485 163 3245002 1 (whether 1 or 0. i.e based on opposite to above value)

543868 814 3580010 1

1372548 871 3580010 1

826682 9000 6868 1

COUNT(AGGR(MAXSTRING(NO),LSR)) ----- This i have used to get 0 or 1 and its working.

COUNT(AGGR(MaxString(LSR),ID))----------This i have used to get 1 format.

How we can combine both expressions in a single expression.

Thanks in advance,

Harshal Patil

Re: Aggr function combination

hic — Tue, 10 Dec 2013 09:08:52 GMT

It sounds as if you want to count the number of distinct combinations of ID and LSR. If so, you should use

Count(distinct ID & '|' & LSR)

No Aggr() needed...

HIC

Re: Aggr function combination

Tue, 10 Dec 2013 09:38:43 GMT

Thanks Henric...

I have applied same as above...but as per my req i have to show 0 at count level.

Id No LSR Count(expected)

750485 165 3245002 0(whether 0 or 1)

750485 163 3245002 1 (whether 1 or 0. i.e based on opposite to above value)

As per your logic am getting like below

Id No LSR Count(expected)

750485 165 3245002 1

750485 163 3245002 1

total =1

Thanks,

Harshal Patil