Most of the part, you can do it at the script level itself.
Day(Date(CashDate,'MM/DD/YYYY')) as CashDay;
Load * Inline [
drop table temp;
drop field CashDay from ReduceData;
PSA for the QVW.
this code works perfectly fine in Qlik sense too.
293197 - Less than Operator.qvw 148.2 K
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others