Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
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.

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: How to auto Load Date.

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
Highlighted

Re: How to auto Load Date.

May be this:

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

Highlighted
Not applicable

Re: How to auto Load Date.

It Worked. Thanks So much Sunny.

Highlighted

Re: How to auto Load Date.

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