Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RKULKARNI4
Contributor III
Contributor III

To find odd number

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-201
11-Nov-202
12-Nov-203
13-Nov-204
14-Nov-203
15-Nov-205
16-Nov-206

 

Thanks in advance

RK

2 Replies
Kush
MVP
MVP

@RKULKARNI4  try below

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