Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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];
and then fill in dates
Thanks.
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.
Thanks Vamsee,
It Worked
Glad it worked for you.
---------------------------------------------
Please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806.