Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

If clause in load script is not giving correct values

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


LOAD country,



if(country='US',Date(TransactionDate,'MM/DD/YYYY'),Date(TransactionDate,'DD/MM/YYYY') as transactiondate1

from test_data.qvd;


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

1 Reply

Hi @SailajaPulugurtha 

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.

Thanks & Regards,
Mayil Vahanan R