Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to Create Date Field from Month and Year

Hi All,

How do i create a Date Field if i have Data for Month and Year on an Applymap Function?

e.g June 2015

Thanks.

6 Replies
Highlighted

Re: How to Create Date Field from Month and Year

You can use MakeDate() function

MakeDate(Year, Month, Day) as Date and if you don't have day you can use any day

MakeDate(Year, Month, 1) as Date

Highlighted
Not applicable

Re: How to Create Date Field from Month and Year

Hi Sunny,

i dont want to include the Day as it will confuse my model that has Days.

do i have to take out only day?

Thanks.

Highlighted

Re: How to Create Date Field from Month and Year

You need to put that there to create a date, but after that you can format it anyway you want. For instance:

Date(MakeDate(Year, Month, 1), 'MMM-YYYY') as Date or my personal favorite

MonthName(MakeDate(Year, Month, 1)) as MonthYear

Highlighted
Partner
Partner

Re: How to Create Date Field from Month and Year

Without Day, you cann't make any date field. 

Highlighted

Re: How to Create Date Field from Month and Year

You can try this also:

Date#(Year & '-' & Month, 'YYYY-MMM') as Date

Highlighted
Contributor
Contributor

How to Create Month as a Variable Input

Hi there, 

I have 3 data tables and want a variable at the top of my worksheet that allows the user to select Month and have the 3 below tables perform their formulations as per the month selected in the variable input. 

Could you please help me create a variable where the end user can select a month and have the below datasets reflect corresponding data to the selected month?

Currently my variable is named 'vAsOfPricingMonthValue'  and the expression is 'Month' .

Thank you in advance!