This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hi I want to make a new field say XYZ,
I want XYZ to be 1 id Actual Date is equal or less than promised date.
XYZ should be 0 otherwise.
How can I achieve this?
Both field in same table then
write in script
if(ActualDate<=PromisedDate,1,0) as Flag
if(Actual Date<= Promised Day,1,0) as XYZ
if( [Actual Date]<=[Promised Date],1,0) as XYZ
drop Table YourTable;
rename table T1 to YourTable;