Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
purna
New Contributor

format

Ex: I have two different date formats like below:

15-2-2020

15/2/2020.

 

How can i  ensure that the date is loaded in consistent format (mm/dd/yyyy)?

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: format

Start with the on-line help and try them for yourself. Then, If you get stuck, feel free to ask more specific questions.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

7 Replies
Highlighted
Luminary
Luminary

Re: format

Are these different formats in the same field? If so, and if all you want to do is ensure that the '-' are converted to '/' then the statement below should work.

Assume that "MyDate" is the field name, then use

Date(Replace(MyDate, '-', '/'), 'DD/MM/YYYY') as MyDate

I hope this helps. Let me know if that's all you're trying to do.

Highlighted
MVP
MVP

Re: format

In Qlik official training the suggesed method is often to use the Alt() function to ensure that you get a valid date along with the Date#() interpreting function and Date() formatting function like this:

 

Date( Alt( Date#( aDateField , 'DD-MM-YYYY') , Date#( aDateField , 'DD/MM/YYYY') , '<unable to interpret date>' ) , 'MM/DD/YYYY')

 

Highlighted
purna
New Contributor

Re: format

Thank you Mr. lblumenfeld for your valuable reply,

Could you please share with me some real-time scenarios of how to use different loads & functions

 

 

Highlighted
Luminary
Luminary

Re: format

Can you be more specific as to what information you're looking for?

Highlighted
purna
New Contributor

Re: format

Hello Lblumenfeld,

sorry for the late reply..

 

Actually I'm looking for videos or PPT's for different types of loads like resident,partial,incremental e.t.c..

And functions like pick,peek,applymap,string functions e.t.c..

 

Highlighted
MVP
MVP

Re: format

Start with the on-line help and try them for yourself. Then, If you get stuck, feel free to ask more specific questions.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Highlighted
Luminary
Luminary

Re: format

If you search these topics in google along with the term “Qlik”you will find quite a bit of explanations and really good examples. Many of those are posts from this site. You’ll see examples of how others have used them to solve problems.

I also highly recommend the Qlik continuous classroom. The videos and training there are excellent.