Re: Aggregation for another field - Qlik Community

danosoft · ‎2020-10-20

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

Anil_Babu_Samineni · ‎2020-10-20

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

danosoft · ‎2020-10-28

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

Brett_Bleess · ‎2020-11-04

@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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

Anil_Babu_Samineni · ‎2020-11-04

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

danosoft · ‎2020-11-05

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?

danosoft · ‎2021-03-01

so... this is not possible in Qlikview?

danosoft · ‎2021-03-08

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?