How to apply the if condition - Qlik Community

chinnuchinni · ‎2017-08-30

Hi all,

I have adatestrt and adateend,

if( adatestart='1900-01-01 ' or adateend= '1900-10-10', 'no entry',min(date))

is this condition correct in straight table to display one date.

its very urgent.

thanks in advance

Anil_Babu_Samineni · ‎2017-08-30

Condition was okay to me. Are you getting any different?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

dineshm030 · ‎2017-08-30

It is a correct condition only.

sunny_talwar · ‎2017-08-30

May be this

If(adatestart = MakeDate(1900, 1, 1) or adateend = MakeDate(1900, 10, 10), 'no entry', Min(date))