Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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),'|')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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

MK_QSL
MVP
MVP

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 .