topic Re: Date = Month in QlikView

Date = Month

knightwriter — Mon, 14 Dec 2015 14:14:29 GMT

Hi All,

Im trying to create a list box for two years previous by month rather than the dates. The expression works below but when I add Month (highlighted in red) it doesnt work.

Any suggestions?

=If(YearStart(Today(),-2)<=YearStart([Car Sales.Date]),Month[Car Sales.Date],)

Thanks

Re: Date = Month

sinanozdemir — Mon, 14 Dec 2015 14:16:16 GMT

Are you putting ()? Because it seems like you are missing parenthesis.

=If(YearStart(Today(),-2)<=YearStart([Car Sales.Date]),Month([Car Sales.Date]),)

Re: Date = Month

knightwriter — Mon, 14 Dec 2015 14:20:29 GMT

Answer by own query but FYI. Use MonthName rather than Month and it works.

=If(YearStart(Today(),-2)<=YearStart([Car Sales.Date]),MonthName[Car Sales.Date],)