Setting a value for calculated dimension based on value of a field

[#1]

Good day,

I am exploring QlikView and learning how to work with expressions, however the syntax is not familiar to me as I am accustomed to Excel and VBA. At the moment I'm trying to do something that would normaly be very simple in Excel:

=IF(A2=DATE(2017,02,28),"Active","Completed")

The above would set the value of a cell to either "Active" or "Completed" text value based on the date value contained in cell A2. Now for QlikView, I would like to create a calculated dimension named "Status" and set its value to either "Active" or "Completed" based on the date value contained in a field named "COMPL".

I would appreciate it if anyone could assist with the correct syntax for this expression in QlikView.

Regards,

Byron

[alexandros17]

Yoiu can use this expression in script or directly as a dimension

IF(A2=MakeDate(2017,02,28),"Active","Completed")

you must pay attention to date format infact the makedate create a new date of type yyyymmdd

hope it helps