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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
chriscools
Creator II
Creator II

how to check if field1 is a multiple of field2

Hello,

i want to check if one field is a multiple of another field,

for example :

field 1 = 14

field 2 = 7

14 is 2 times 7 so ok.

then i want a null value, so i can hide those records

field 1 = 13

field 2 = 7

13 divided by 7 is not a round number, so not ok.

then i would like the value 1, so i can show al those records were the values are not ok

thanx!

chris

0 Replies