Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Creator III
Creator III

Aggregation for another field

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

 

danosoft_0-1603186205032.png

 

7 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
danosoft
Creator III
Creator III
Author

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
Support (Former)
Support (Former)

@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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
danosoft
Creator III
Creator III
Author

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
Creator III
Creator III
Author

so... this is not possible in Qlikview?

danosoft
Creator III
Creator III
Author

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?