Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this
=If(MonthStart(FactDate) >= MonthStart(Today(), -14), Date(MonthStart(FactDate), 'MMM YY'))
May be try this
=If(MonthStart(FactDate) >= MonthStart(Today(), -14), Date(MonthStart(FactDate), 'MMM YY'))
Thanks Sunny
This has worked for me
Kind Regards
Helen