Date Trim/Merg

[Anonymous]

Hello Qlik family,

I am new to this forum and qlikview in general and I have a question I really want to know the answer to.

Am developing an app with date format like the one below in my data,

[Original data]

12/04/2016

01/04/2017

10/04/2018

I have also created a seperate data with date format like

[Created data]

YEAR

2016

2017

2018

MONTH

01

02

03

I really want to know is there a way or possibility to trim the date in my original data to link  it to my created data to do the magic ??

so for email: when I click just [2017] or the month [01] it will give me all the dates relates to my origianl data or it will link both dates together.. ???

Thanks

[vamsee]

Maybe try this. Depending on the column you want to join.

Original:

LOAD

          Date,

          Year(Date) as YEAR,

          Month(Date) as Month

From Source;

Also, on the same note you can create dates for the month year combinations in your Created data table like the following

LOAD

          *,

          MakeDate(YEAR, MONTH) as Date

From [Created Data];

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFun...

and then fill in dates

Fill Dates between dates

Thanks.

[Anonymous]

Thanks for the rapid respond. My server is down right now and I will give it a go tomorrow morning.

Ones again Thanks very much.

[Anonymous]

Thanks Vamsee,

It Worked

[vamsee]

Glad it worked for you.

---------------------------------------------

Please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806.