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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Multiple selected values in Action with =YEAR(TODAY())

Hei community,

I am struggling with a simple task. I need to select multiple values in the sheet Action Select values in a field.

I need to use like =YEAR(TODAY()) and =YEAR(TODAY()) - 1.

It seems that the formula is OK, but the values do not select.

='($(=YEAR(TODAY()))|$(=YEAR(TODAY()) - 1))'

MindaugasBacius_0-1673426836325.png

I have tried many variations but nothing helped. Any ideas on how could I accomplish this?

Thank you!

 

 

Labels (1)
1 Solution

Accepted Solutions
Mark_Winter
Creator
Creator

='$(=YEAR(TODAY()));$(=YEAR(TODAY()) - 1)'

View solution in original post

3 Replies
Mark_Winter
Creator
Creator

='$(=YEAR(TODAY()));$(=YEAR(TODAY()) - 1)'

MindaugasBacius
Partner - Specialist III
Partner - Specialist III
Author

@Mark_Winter you are a genius! 🙂

Mark_Winter
Creator
Creator

I wouldn't go that far but I'm happy to have eased your suffering, friend 😸