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: 
qlikviewaf
Creator
Creator

Select multiple values in a field based on another fiel

 

Hi,

i did a button with the rule below. "select in field".

This is working fine only if just 1 values in Year is selected! If i select 2 years values and then i click the button is not working.
How i can get this working with multiple values selected on field Year ???

Thank you!!

YEAR SELECTION.PNG

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

use this expressions in the search string :

='(' & concat(distinct Year,'|')&')'

Brett_Bleess
Former Employee
Former Employee

Pretty certain the prior post should do the job, but just in case, I am including the Help link to the Actions, just scroll down until you see the Actions section, there are some further notes on things there that may be helpful.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Button2.htm

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.