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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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