topic Re: Aggregation in text box in QlikView

Aggregation in text box

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

Hi can anybody suggest how to use below expreesion in text object

=if(aggr(count( distinct issueid),exceptionid,[cob date])>1),

count(distinct exceptionid)

The above expression gives desired result in chart but i am not able to achieve it in text object

my requirement is to find out count of exception id's if it is having more than one issue id

Thanks,

Shruthi

sunny_talwar — Tue, 13 Jun 2017 19:29:00 GMT

May be try this

Sum(Aggr(If(Count(DISTINCT issueid) >1, Count(DISTINCT exceptionid), exceptionid, [cob date]))

rubenmarin — Tue, 13 Jun 2017 19:30:40 GMT

Hi, maybe with:

=if(Sum(aggr(count( distinct issueid),exceptionid,[cob date]))>1,

count(distinct exceptionid))

CarlosAMonroy — Tue, 13 Jun 2017 19:34:00 GMT

Hi Shruthi,

You can try:

=if(sum(aggr(count( distinct issueid),exceptionid,[cob date]))>1,count(distinct exceptionid))

Carlos M

shruthibk — Tue, 13 Jun 2017 19:59:07 GMT

Thank you all for your quick response