topic Re: format in QlikView

format

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

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)?

Re: format

lblumenfeld — Sat, 15 Feb 2020 06:57:53 GMT

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.

Re: format

petter — Tue, 18 Feb 2020 08:42:23 GMT

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')

Re: format

purna — Sat, 15 Feb 2020 11:21:56 GMT

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

Re: format

lblumenfeld — Mon, 17 Feb 2020 03:14:14 GMT

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

Re: format

purna — Tue, 18 Feb 2020 03:03:25 GMT

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..

Re: format

jonathandienst — Tue, 18 Feb 2020 05:48:57 GMT

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

Re: format

lblumenfeld — Tue, 18 Feb 2020 06:55:17 GMT

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.