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: 
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