Discussion Board for collaboration related to QlikView App Development.
I am not able to derive correct value for a field using if condition in edit script. Here is the scenario. I am loading a QVD file as below
if(country='US',Date(TransactionDate,'MM/DD/YYYY'),Date(TransactionDate,'DD/MM/YYYY') as transactiondate1
I have tried loading the qvd and saw that transactiondate1 for all the country values is in the format of MM/DD/YYYY only but not DD/MM/YYYY for the countries other than US
I think, you repeated the question in several posts. Please verify below link and try to close any of the threads and follow up in single thread.