Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@RKULKARNI4 try below
if(odd(Number),'Odd','Even') as Number_Flag