topic Re: Facing problem with date in qlikview in QlikView

Facing problem with date in qlikview

tripatirao — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

Attached is the excel file where my month and year are in text format.

By using that fields I need to calculate Fiscal month,Fiscal Year, Calender month ,Calender year by using that values

How Can i those value to number format.

Means if I apply num(Month) it should show value like 5 (If I select may).

Please help me.

MindaugasBacius — Tue, 06 Dec 2016 14:47:15 GMT

Try like this:

=date(Date#('Apr-2011', 'MMM-YYYY'))

By knowing how to convert the date into numbers you could create a calendar.

sunny_talwar — Tue, 06 Dec 2016 14:48:28 GMT

May be like this:

Date(MonthStart(Date#(Month, 'MMM-YYYY')), 'MMM-YYYY') as MonthYear

tripatirao — Tue, 06 Dec 2016 15:26:01 GMT

Dear Sunny,

Thanks for Reply.

How can I create master calender with financial year, month from MonthYear field.

Regards

Tripati

sunny_talwar — Tue, 06 Dec 2016 15:27:45 GMT

The same way you would do with a date field. Just used MonthYear field instead of date in your master calendar creation script