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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
SMiller_FL
Contributor III
Contributor III

weighted calculation with a filter

I have a column called [countall] that has a 1 in every row that I use just for math by the way. I have a normal formula for counting all that are in column [Tier-TierNum] and are '3':

Count({<[Tier-TierNum]={"3"}>}[countall])   = this works perfectly

But they want this count weighted by  a factor of 2.22

When I try this it doesn't work:

count({<[Tier-TierNum]={"3"}>}[countall]*2.22)

I can not find the correct aggr syntax to make this work. 

 

1 Solution

Accepted Solutions
Angela_Zhou
Contributor III
Contributor III

Should it be:
   = 2.2 * Count({<[Tier-TierNum]={"3"}>}[countall])

Angela Z.

View solution in original post

2 Replies
Angela_Zhou
Contributor III
Contributor III

Should it be:
   = 2.2 * Count({<[Tier-TierNum]={"3"}>}[countall])

Angela Z.
SMiller_FL
Contributor III
Contributor III
Author

Thanks!!!!