Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
SailajaPulugurtha
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

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

1 Reply
MayilVahanan

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-b...

Thanks & Regards,
Mayil Vahanan R