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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Jérôme5625
Creator
Creator

Calcul on table QLIK

Hello,
I've created a variable that only takes into account the filters (months= January) on the dashboard except for the country. However, when I perform a calculation or display the value of this variable in my table, it is filtered and I get the value 1 instead of 7.


I want the value 7 in my table on each line instead of 1.
Thanks again for your help.
bon weekend

Labels (4)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Take a look at the key word total. See: Define Aggregation Scope  

Try something like this 

Count({Pays} total distinct Client)

View solution in original post

2 Replies
Vegar
MVP
MVP

Take a look at the key word total. See: Define Aggregation Scope  

Try something like this 

Count({Pays} total distinct Client)

Jérôme5625
Creator
Creator
Author

thanks you for your help!! 

have a nice week

Jérôme