Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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!