Last 14 months to appear in Dimension of pivot table

[helen_pip]

Dear Qlikview user

I have created  a straight table which has a dimension of FactDate

FactDate is our default date field and contains dates for every day of the year I.e. 01/06/2017

However I would like to limit the number of months being displayed in the straight table 

I have written my dimension as follows, but it does NOT seem to return me the last 14 months and still returns every month

=if(MonthStart(FactDate>=MonthStart(AddMonths(Today(), -14))), Date(FactDate, 'MMM YY'))

Any help in amending the Dimension so that I can limit the dimension data would be greatly appreciated

Kind Regards

Helen

[sunny_talwar · Accepted solution]

May be try this

=If(MonthStart(FactDate) >= MonthStart(Today(), -14), Date(MonthStart(FactDate), 'MMM YY'))

[helen_pip]

Thanks Sunny

This has worked for me

Kind Regards

Helen