topic Date Help in QlikView

Date Help

arusanah — Fri, 01 Jul 2016 15:23:51 GMT

Hi ,

I have a monthYear field coming from master calender as num.

Date(monthstart(TempDate), 'MMM-YYYY') AS MonthYear,

while as I used following expression in my Data source to generate monthYear field .

Month(date#(MTH,'MMM'))&'-'&YR as MonthYear, this one comes as text

I tried using num in my datasource expression but it converts it to num .

how can I make my second expression to match my master calendar type.

sunny_talwar — Fri, 01 Jul 2016 15:25:27 GMT

May be this:

Date(MonthStart(Date#(Month(date#(MTH,'MMM')) & '-' & YR, 'MMM-YYYY')), 'MMM-YYYY') as MonthYear

or this (simpler version of the above)

Date(MonthStart(Date#(MTH & '-' & YR, 'MMM-YYYY')), 'MMM-YYYY') as MonthYear

arusanah — Fri, 01 Jul 2016 15:43:47 GMT

Thanks Sunny!!!