Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I already seen several posts but couldn't find the solution. I tried to achieve by using trigger - select in field, getfieldselections(Year)
This is working perfectly with single year selection. But If I select multiple year this doesnt work and it clear the Year selections.
Please help me if you have some ideas to get it work with multiple selections.
Thanks.
Regards,
Neha
May be this
='(' & 2015 | 2016 & ')'
Or
Concat(GetFieldSelections(Year),'|')
Hi..
You are working in QlikView or in QlikSense
May be try this
='(' & GetFieldSelections(Year, '|') & ')'
Or ='(' & GetFieldSelections(Year, '|', 100) & ')'
Hi,
If you want to select many values you have to use the syntax with parenthesis around it and a pipe in between the values. Try this as "Search string":
='(' & Concat (DISTINCT Year, '|') & ')'
Brgds
Johan
Example attched
Please refer attached snapshot.
If your problem has been solved then mark this as "correct & Helpful" to close this thread .