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

Announcements
Join us in Toronto Sept 9th 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))