Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
drohm002
Creator II
Creator II

display specific values from a dimension field

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!

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

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

View solution in original post

2 Replies
m_woolf
Master II
Master II

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

Taoufiq_Zarra

Maye be

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

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉