topic Re: Date format with condition in QlikView

Date format with condition

QV_learner — Sat, 16 Nov 2024 21:10:03 GMT

Hi,

I am working on an application where I need to change the date format according to the value the user selects.

Ex: Suppose for a region field, if user selects US, the date format should be MM/DD/YYYY and if user selects UK, the format should be DD/MM/YYYY. (only for example purpose)

I tried to use if condition in script; but it's not working.

Could you please help me for the same?

And is it possible to do the same in table box or straight table, where according to the region the date in the respective format be shown?

Thank you!

Re: Date format with condition

Somasundaram — Wed, 27 Mar 2019 13:30:59 GMT

Use this,

ABC:
Load * Inline [
A,b
US,02/03/2019
UK,02/17/2019
US,02/19/2019

];

AA:
load
A,
b,
If(A='US',Date(b,'MM/DD/YYYY'),Date(b,'DD/MM/YYYY')) as new_date
Resident ABC;

drop Table ABC;

Re: Date format with condition

Shubham_Deshmukh — Wed, 27 Mar 2019 13:43:58 GMT

Try this,

=if(yourField='US',date(today(),'MM/DD/YYYY'),
if(yourField='UK',date(today(),'DD/MM/YYYY')))