Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
GabrielOtet
Contributor III
Contributor III

Filter values greater than divide

Hi all,

 

I have a problem when calculating a specific value as following:

count({<field1={"$(=[field1]*3/[field2])>5"}>} field1)

 

Actually what I want to do is to count all the values that divided to another value from a collumn of the table are greather than 5. 

Theoreticaly the logic should be correct but practically I get different results compared with what I expect.

 

can someone help me here?

 

Gabriel

10 Replies
GabrielOtet
Contributor III
Contributor III
Author

I'm thinking now that maybe this is the reason: The fact that there are values that are equal. Applying this filter to them, can be the reason for counting 1k values for example as one.

If this would be, then there is a need for calculating ALL the fields, it doesn't matter if they are distinct or not