Create a New Field

[#1]

Hi Community,

Just need your help to add a Conditional field in qlikview.

Two Existing Fields:

Agreed Date

Completed Date

New Field:

If Completed Date <= Agreed Date then "MET"

If Completed Date > Agreed Date then "MISS"

Thank you.

[juraj_misina]

Should be simple. Try

If([Completed Date] <= [Agreed Date], 'MET', 'MISS')    as NewField