Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

And-Mode in QlikSense

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

And-Mode in QlikSense

Last Update:

May 10, 2022 3:23:50 PM

Updated By:

Jamie_Gregory

Created date:

Feb 24, 2018 1:46:21 AM

In QlikSense, multiple selections within a field are by default interpreted as logical OR, which means that data associated to any of the selected field values will be shown in the other fields.

However, some users may need to have AND-mode selection instead: when multiple selections are made in a list, only data associated to all of the selected field values will be shown in the other fields.

Resolution:


AND-mode is not an available option in QlikSense.  However, with a minor SET ANALYSIS expression syntax we can create the right context on a chart to show the output in an "AND" context.

See Generating AND, OR, NOT selection logic in Qlik Sense (Source: Qlik Community) for details. 
 

Need more help? For tips and tricks and examples on advanced app development, join our active Qlik Community.
Labels (2)
Version history
Last update:
‎2022-05-10 03:23 PM
Updated by: