If clause in load script is not giving correct values

SailajaPulugurtha — Mon, 02 Nov 2020 03:13:32 GMT

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

date_test:

LOAD country,

employee,

workcountry,

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

Re: If clause in load script is not giving correct values

MayilVahanan — Mon, 02 Nov 2020 04:12:27 GMT

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.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Date-formatting-working-as-expression-but-not-as-dimension-in/td-p/1757610

topic If clause in load script is not giving correct values in QlikView

If clause in load script is not giving correct values

Re: If clause in load script is not giving correct values