Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
michaelneck
Contributor II
Contributor II

Multiple selections for GetFieldSelections in the same field...

Hi All,

I am trying to exclude two values in a field when they are selected together. The below works when selected individually but not when selected together. Is there a way to do this? Any help would be appreciated.

Individually works:

GetFieldSelections([Job Category Desc])<>'Executive' AND GetFieldSelections([Job Category Desc])<>'Senior Management'

Failed Attempts to include when both selected:

GetFieldSelections([Job Category Desc])<>('Senior Management' AND 'Executive')

GetFieldSelections([Job Category Desc])<>('Senior Management' OR 'Executive')

GetFieldSelections([Job Category Desc])<>(Senior Management|Executive)

1 Solution

Accepted Solutions
sunny_talwar

May be this

SubStringCount('|' & GetFieldSelections([Job Category Desc], '|,|') & '|', '|Executive|') = 0 and

SubStringCount('|' & GetFieldSelections([Job Category Desc], '|,|') & '|', '|Senior Management|') = 0

View solution in original post

2 Replies
sunny_talwar

May be this

SubStringCount('|' & GetFieldSelections([Job Category Desc], '|,|') & '|', '|Executive|') = 0 and

SubStringCount('|' & GetFieldSelections([Job Category Desc], '|,|') & '|', '|Senior Management|') = 0

View solution in original post

michaelneck
Contributor II
Contributor II

That worked perfectly Sunny! Thanks a lot!