Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator 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
swuehl
MVP
MVP

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

sunny_talwar

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
Creator III
Creator III
Author

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

sunny_talwar

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
Creator III
Creator III
Author

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