Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
CHRIS_Singa
Creator
Creator

Aggregation function with no filter allowed

Hello everyone,

I got a question about Aggr() Function.
How can I use the function {1} which allow no filter with the aggregation function.

Example :
Count(aggr(if(Country='USA', count( distinct Client)),Client))
How can I add {1} to allow no filter ?

Thank you for the feedback

Labels (7)
1 Solution

Accepted Solutions
CHRIS_Singa
Creator
Creator
Author

@BrunPierre  : I tried your script but still was not. And then, I tried the function below. Now the result is correct, no filter applied. Thank you 🙏 

 Count({1}aggr({1}if({1}Country='USA', count({1} distinct Client)),Client))

View solution in original post

4 Replies
BrunPierre
Partner - Master II
Partner - Master II

As below.

Count({1}aggr({1}if(Country='USA', count( distinct Client)),Client))

CHRIS_Singa
Creator
Creator
Author

Not working, Dimension like Month is still working @BrunPierre 

BrunPierre
Partner - Master II
Partner - Master II

Correction!

Count({1}aggr({1}if(Country='USA', count({1} distinct Client)),Client))

CHRIS_Singa
Creator
Creator
Author

@BrunPierre  : I tried your script but still was not. And then, I tried the function below. Now the result is correct, no filter applied. Thank you 🙏 

 Count({1}aggr({1}if({1}Country='USA', count({1} distinct Client)),Client))