Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasx15
Contributor III
Contributor III

Agrr with count and sum

Hello everybody. I have a doubt, how could Aggr use a sum within two count fields? My expression is like this:. What would be wrong?

 

 

			=COUNT(AGGR({<CD_HISTORY={57,89,10}>}
COUNT(
		{<CD_PROT={3535},FL_TYPE={'1 - ALT'}>} 
	%NR_PRESCR_PRODUCT)
+
COUNT({<FL_TYPE={'1 - ALT'}>}
	NR_SEQUENCE.SCALE)) DISTINCT NR_CLIENT)

 

Labels (1)
2 Replies
lironbaram
Partner - Master III
Partner - Master III

it seems you miss the field you want to use as the dimension in the AGGR function 

lucasx15
Contributor III
Contributor III
Author

Thank you for reply!

 

my values ​​are still coming in null. the idea is that everything I'm counting within that sum of counts is aggregated by nr_client, I don't know if the aggr I'm doing is incorrect.