To find odd number

[RKULKARNI4]

Hello Team,

From below table I need to find only odd values.How it can be done in qlik sense which function i need to use.Please advise.

Date	Number
10-Nov-20	1
11-Nov-20	2
12-Nov-20	3
13-Nov-20	4
14-Nov-20	3
15-Nov-20	5
16-Nov-20	6

Thanks in advance

RK

[dplr-rn]

use even function

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

[Kushal_Chawda]

@RKULKARNI4  try below

if(odd(Number),'Odd','Even') as Number_Flag