Discussion Board for collaboration related to QlikView App Development.
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?
May be with Aggr(NoDistinct <Your Expression Here>, DES_PR_PDR)
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
@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!
Can you explain more with sample data to demonstrate the issue?
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?
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?