topic Re: display specific values from a dimension field in QlikView

display specific values from a dimension field

drohm002 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: display specific values from a dimension field

m_woolf — Wed, 25 Mar 2020 17:49:48 GMT

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

Re: display specific values from a dimension field

Taoufiq_Zarra — Wed, 25 Mar 2020 17:57:06 GMT

Maye be

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