QlikView App Dev

[drohm002]

Hi, I have a field called "Month-Year", that has values like Jan-17, Jan-18, Jan-19, Feb-17, Feb-18, Feb-19 and so on.  How can I get the dimension to display only the values from 2018?  Thank you for the help!

[m_woolf · Accepted solution]

=if(year("Month-Year")=2018,"Month-Year")

[Taoufiq_Zarra]

Maye be

if(Year(Date#(Field,'MMM-YY'))='2018',Field)