topic Re: KPI based on Aggr() function in QlikView

KPI based on Aggr() function

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

Hi all i have a problem: i have a KPI that run in this way

sum( total <column A>

aggr(

if( etc etc etc, 1), column B, column C)

but the aggregation function, although I create a field that is the concatenation of my 2 fields "campoB" and "Campo C" through autonumberhash, decides to cut me off the results from the count !! I don't know what to do anymore ... if I remove the aggregation function the KPI does not work, if I put it wrong the calculation ... I can't add the 1 of my "if" without the aggr?

Re: KPI based on Aggr() function

sunny_talwar — Fri, 14 Jun 2019 11:41:08 GMT

Would you be able to share a sample to show the issue you are running into?

Re: KPI based on Aggr() function

rubenmarin — Fri, 14 Jun 2019 12:25:15 GMT

Maybe you need to add columnA in aggr parameters?

As said by Sunny a sample will be nice to check.

Re: KPI based on Aggr() function

Daora342423 — Fri, 14 Jun 2019 14:11:55 GMT

sum( total <[RST Codice]>
aggr(
if(

sum( total <A3GCounter, [Causale (categoria)]>
{<
Transaction_Day={">=$(=vA3GNumeroGiorni)"},[Causale (descrizione)]-={'INIZIATIVA 2%'},DESC_TP_SOTT_PAG_FEND-={'SUCCESSIONE','RITENUTA NON DOVUTA','RIM.NO FIRMA C.F.'},DESC_TP_PAG_FEND-={'RID','REINV.DIST.DIV.REALI'},FLG_IS_CF={0},AnnoMeseCifre=,DateStamp=,Transaction_OrderDate_Num={">=$(vA3G_DataRangeMin)<=$(vA3G_DataRangeMax)"}, [Causale (categoria)] = {'ACQ','VERS','SWIN','SWOUT','PREL','VEN'}
>}
fabs([Controvalore lordo transazione])) > vA3GSoglia

and

count( total<[RST Codice]>
{<
Transaction_Day={">=$(=vA3GNumeroGiorni)"},[Causale (descrizione)]-={'INIZIATIVA 2%'},DESC_TP_SOTT_PAG_FEND-={'SUCCESSIONE','RITENUTA NON DOVUTA','RIM.NO FIRMA C.F.'},DESC_TP_PAG_FEND-={'RID','REINV.DIST.DIV.REALI'},FLG_IS_CF={0},AnnoMeseCifre=,DateStamp=,Transaction_OrderDate_Num={">=$(vA3G_DataRangeMin)<=$(vA3G_DataRangeMax)"}, [Causale (categoria)] = {'ACQ','VERS','SWIN','SWOUT','PREL','VEN'}
>}
distinct (A3GCounter&[Causale (categoria)])) > vA3GNumeroTransazioni,

1
), A3GCounter, [Causale (categoria)]))

this is my problem

Re: KPI based on Aggr() function

sunny_talwar — Fri, 14 Jun 2019 14:13:46 GMT

I see an expression... but I still don't see the problem 🙂

Re: KPI based on Aggr() function

Daora342423 — Fri, 14 Jun 2019 14:56:30 GMT

The count of the expression is wrong

Re: KPI based on Aggr() function

sunny_talwar — Fri, 14 Jun 2019 15:49:30 GMT

okay good... so you know what is not right... how do you want to help you? Just by looking at the expression, how can I tell you what to fix?