topic Re: How to auto Load Date. in QlikView

How to auto Load Date.

Mon, 15 Feb 2016 18:50:39 GMT

Hello Everyone,

I am new to Qlik view please help me load the date in to my table while loading itself.

Here is my situation.

I have two tables. Table A which is 2015 has the date field included while Table B which is 2016 does not have date field included. So I am trying to include the date field while loading itself.

I have tried the below statements and its giving me the string

The above statement is giving me the date. but in a string format. The result is like this:

I have also tried using

and its giving me the below result

Can anyone Please help me get the date auto loaded and in the actual date format rather than a string. Also I want it in the ascending order i.e first 2015 and then 2016 order.

Thanks So much.

Re: How to auto Load Date.

sunny_talwar — Mon, 15 Feb 2016 19:19:28 GMT

May be this:

Date(Floor(MonthEnd(Date#(Mid(FileName(), 16, 2) & '-' & Mid(FileName(), 11, 4), 'MM-YYYY')))) as MonthYear

Re: How to auto Load Date.

Mon, 15 Feb 2016 19:37:58 GMT

It Worked. Thanks So much Sunny.

Re: How to auto Load Date.

sunny_talwar — Mon, 15 Feb 2016 19:41:34 GMT

Awesome

Please close the thread down by marking correct answer (Qlik Community Tip: Marking Replies as Correct or Helpful)

Best,

Sunny