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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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!!!!