topic Re: Aggregation for another field in QlikView

Aggregation for another field

danosoft — Tue, 20 Oct 2020 09:34:43 GMT

Hi i have this problem i have this straight table (chart) the dimension is DES_PR_PDR and MONTHS, all is ok, but i want the field CLIENT (nr.) you see in the chart, not be aggregate for DES_PR_PDR but DES_PR_CLI (for MONTHS yes), is possible do that?

Thanks

Re: Aggregation for another field

Anil_Babu_Samineni — Tue, 20 Oct 2020 17:13:42 GMT

May be with Aggr(NoDistinct <Your Expression Here>, DES_PR_PDR)

Re: Aggregation for another field

danosoft — Wed, 28 Oct 2020 08:18:43 GMT

No sorry it not work, if i put this on my expressions

Aggr(NoDistinct Count(COD_CLIENTE), DES_PR_CLI)

i want the field CLIENT (nr. COD_CLIENTE) you see in the chart, not be aggregate for DES_PR_PDR but DES_PR_CLI

Re: Aggregation for another field

Brett_Bleess — Wed, 04 Nov 2020 16:17:28 GMT

@Anil_Babu_Samineni Any chance you have a bit of time to spare to circle back on this one to see if you have anything further to add, thanks in advance as always, glad to see you back!

Regards,
Brett

Re: Aggregation for another field

Anil_Babu_Samineni — Wed, 04 Nov 2020 18:06:10 GMT

Can you explain more with sample data to demonstrate the issue?

Re: Aggregation for another field

danosoft — Thu, 05 Nov 2020 13:27:03 GMT

Hi, thanks for reply but the problem is simple like you see in the post, i try to explain again and more:

I have a straight table (chart) the dimension is DES_PR_PDR and MONTHS (two dimension like you see in the picture before).

For the field Pdr (nr.) is all ok (you see in the picture the field) becouse it is the expression Count(DISTINCT PDR)

But for the field CLIENT (nr.) you see in the picture, the expression is Count(DISTINCT COD_CLIENTE) i NOT want it be aggregate for the dimension DES_PR_PDR, but for DES_PR_CLI (and for MONTHS yes).

So i ask: is possible to do that in the same chart?

Re: Aggregation for another field

danosoft — Mon, 01 Mar 2021 16:15:03 GMT

so... this is not possible in Qlikview?

Re: Aggregation for another field

danosoft — Mon, 08 Mar 2021 10:32:42 GMT

Hi i add an sample data,

I want the ONLY field CLIENTI (nr. COD_CLIENTE) you see in the chart, not be aggregate for DES_PR_PDR but DES_PR_CLI

Is possible to do that in Qlikview?