Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to auto Load Date.

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.

1 Solution

Accepted Solutions
sunny_talwar

Awesome

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

Best,

Sunny

View solution in original post

3 Replies
sunny_talwar

May be this:

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

Not applicable
Author

It Worked. Thanks So much Sunny.

sunny_talwar

Awesome

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

Best,

Sunny