Year selection should not clear with clear filters button

[nehasaxena]

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

[Anil_Babu_Samineni]

May be this

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

Or

Concat(GetFieldSelections(Year),'|')

[sarvesh]

Hi..

You are working in QlikView or in QlikSense

[sunny_talwar · Accepted solution]

May be try this

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

[sunny_talwar]

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

[johanlindell]

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]

Clear All Document Event in QlikView - YouTube

[#8]

Example attched

[sarvesh]

Please refer attached snapshot.

[sarvesh]

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