topic Re: How to Create Date Field from Month and Year in QlikView

How to Create Date Field from Month and Year

Tue, 28 Jul 2015 10:28:43 GMT

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.

Re: How to Create Date Field from Month and Year

sunny_talwar — Tue, 28 Jul 2015 10:29:51 GMT

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

Re: How to Create Date Field from Month and Year

Tue, 28 Jul 2015 10:32:31 GMT

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.

Re: How to Create Date Field from Month and Year

sunny_talwar — Tue, 28 Jul 2015 10:34:55 GMT

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

Re: How to Create Date Field from Month and Year

manojkulkarni — Tue, 28 Jul 2015 10:45:18 GMT

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

Re: How to Create Date Field from Month and Year

sunny_talwar — Tue, 28 Jul 2015 10:49:38 GMT

You can try this also:

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

How to Create Month as a Variable Input

DeeC84 — Wed, 13 May 2020 00:43:57 GMT

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!