Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
nehasaxena
Creator II
Creator II

Year selection should not clear with clear filters button

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

1 Solution

Accepted Solutions
sunny_talwar

May be try this

='(' & GetFieldSelections(Year, '|') & ')'

View solution in original post

10 Replies
Anil_Babu_Samineni

May be this

='(' & 2015 | 2016 & ')'

Or

Concat(GetFieldSelections(Year),'|')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sarvesh
Creator III
Creator III

Hi..

You are working in QlikView or in QlikSense

sunny_talwar

May be try this

='(' & GetFieldSelections(Year, '|') & ')'

sunny_talwar

Or ='(' & GetFieldSelections(Year, '|', 100) & ')'

johanlindell
Partner - Creator II
Partner - Creator II

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

Not applicable

Example attched

sarvesh
Creator III
Creator III

Please refer attached snapshot.qlik.jpg

sarvesh
Creator III
Creator III

If your problem has been solved then mark this as  "correct & Helpful" to close this thread .