topic Re: DATE format/join in QlikView

DATE format/join

master_student — Wed, 25 Nov 2020 16:16:04 GMT

Hello dear community,

I have a date field with that format, how to convert them to date :

2-(january 2016)

I need to convert those field into date add/mm/yyyy and then convert them into number using the autonumber function to link them with my calendar dimension

An other question;

I have 2 tables that are linked by 2 field CDR and LB

buget:

load cdr,LB

resident..

DA:

load cdr,LB

resident ...

I think that by default only the commun fields values are the result of that join, in my case I need all values from the 2 tables to be displayed.

Thanks for you collaboration

Re: DATE format/join

swuehl — Mon, 23 May 2016 20:06:14 GMT

What's the logic behing converting Nov 30 2015 into a January 2016 date?

Re: DATE format/join

sunny_talwar — Mon, 23 May 2016 20:06:17 GMT

To convert to another format, you can try this:

Date(MonthStart(DateField), 'MMMM YYYY') as DateFieldNewFormat

Not sure I understand your 2nd question. Can you elaborate?

Re: DATE format/join

master_student — Mon, 23 May 2016 20:11:07 GMT

NO, you misunderstood me.

I need to convert 31/11/2015 00:00:00 into DD/MM/YYYY

and 01/2016 to DD/MM/YYYY

Re: DATE format/join

sunny_talwar — Mon, 23 May 2016 20:15:53 GMT

May be using Alt function here:

Date(Alt(Date#(DateField, 'MM/YYYY'), Floor(Date#(DateField, 'DD/MM/YYYY hh:mm:ss'))), 'DD/MM/YYYY') as NewDateField

Re: DATE format/join

master_student — Mon, 23 May 2016 20:22:34 GMT

I mean when we have two tables linked by 2 fields, only the common values of those fields are displayed, In my case I need all values of the two tables to be displayed.

I tried Date(MonthStart(DATE_GL),'MM/YYYY') as DateFieldNewFormat but it didn't work.

Thanks