Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-10-26 06:39 PM

Flag creation for the dates


I have Date Dimension like below for multiple years.But, I don't want all years into qlikview.

How to create a flag and pull the date for Jan'13-Dec'13  as current year and Jan'14-Dec'14 as previous year??

Date_key_ID,                                        FullDT

20120101 (YYYY-MM-DD)                      2012-01-01

20120102,

20120103,

...

20121230

20121231..

How to inner Join dates in Date dimension with Clm_recieve_DT in T_FCT table??

Clm_recieve_DT

20120101,

20120102,

20120103,

...

246 Views
0 Likes
0 Replies