topic Re: Date field help in QlikView

Date field help

Fri, 26 Feb 2016 02:37:39 GMT

I have a field called Expense Year - Month.

Expense Year - Month

12/13/1987

11/24/1987

1/3/2016

2/5/2016

1/6/2017

2/6/2017

2/6/2018

3/6/2018

I only want to display

1/3/2016

2/5/2016

1/6/2017

2/6/2017

basically 12 months from current month.How can I do this ?

Thanks bunch.

Re: Date field help

jagan — Fri, 26 Feb 2016 02:50:31 GMT

Hi,

Try like this in set analysis

=Sum({<YearMonth = {'>=$(=MonthStart(Today()))<=$(=MonthEnd(Today(), 11))'}>} MeasureName)

Regards,

jagan.

Re: Date field help

Fri, 26 Feb 2016 03:06:58 GMT

IF([Expense Month-Year] >= MonthStart(Today()) ,

IF([Expense Month-Year] <= MonthEnd(Today()) + 12,[Expense Month-Year]))

I have this as expression in my list box and its not displaying proper year.

Re: Date field help

jagan — Fri, 26 Feb 2016 03:10:54 GMT

HI,

Try like this

IF([Expense Month-Year] >= MonthStart(Today()) ,

AND [Expense Month-Year] <= MonthEnd(Today(), 12) ,[Expense Month-Year])

Hope this helps you.

Regards,

jagan.

Re: Date field help

Fri, 26 Feb 2016 03:16:00 GMT

Awesome.That worked..Thank you.