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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
zalibra
Contributor III
Contributor III

IF ELSE condition for integer and decimal

Trying to figure out how the IF/ELSE statement should be structured in tMap when trying to filter integers and decimals (I know how to do it for String and Date, but can't seem to figure out for numbers).

 

I've used the below for now and it works, but trying to see if there's another method where I can specify directly "IF integer, accept value, ELSE null"

row1.field1 % 1 == 0 ? row1.field1 : null 

 

 

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

Ternary notation (what you're using) is the solution to replace IF/ELSE into tMap.

View solution in original post

1 Reply
TRF
Champion II
Champion II

Ternary notation (what you're using) is the solution to replace IF/ELSE into tMap.