Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

master_student
Contributor III

DATE format/join

Hello dear community,

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

1- Capture.JPG

2-Capture.JPG(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

5 Replies
MVP
MVP

Re: DATE format/join

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

Re: DATE format/join

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?

master_student
Contributor III

Re: DATE format/join

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

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

master_student
Contributor III

Re: DATE format/join

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