topic Re: How to Use and Condition in Different Filters in Qlik Sense in App Development https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208870#M23133 <HTML><HEAD></HEAD><BODY><P>So, a particular filter can allow for either be AND or OR based selection. If you use the method specified in the blog above, you should be able to allow your user to do an AND based selection.</P><P></P><P>This image from the blog shows AND and OR based selection</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/140257_Capture.PNG" style="height: 526px; width: 620px;" /></P><P></P><P>One at top is showing just one bar because its the only one which includes A, B and C skills. Whereas the one at bottom is showing all places where either A or B or C is one of the skills.</P><P></P><P>Does that make sense?</P></BODY></HTML> Tue, 11 Oct 2016 11:39:04 GMT sunny_talwar 2016-10-11T11:39:04Z How to Use and Condition in Different Filters in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208865#M23128 <HTML><HEAD></HEAD><BODY><P>Hello everyone!</P><P></P><P>So I have been working with qlik sense for a while now, and I know that the default behavior of qlik is an OR operator when it comes to selections, right? Can anyone tell me how to use "AND" operator when it comes to filter panes.</P><P></P><P></P><P></P><P>Thanks!</P></BODY></HTML> Mon, 10 Oct 2016 06:20:48 GMT https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208865#M23128 Anonymous 2016-10-10T06:20:48Z Re: How to Use and Condition in Different Filters in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208866#M23129 <HTML><HEAD></HEAD><BODY><P>Check this link out:</P><P><A href="https://community.qlik.com/docs/DOC-9035">AND mode in Qlik Sense</A></P></BODY></HTML> Mon, 10 Oct 2016 12:07:00 GMT https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208866#M23129 sunny_talwar 2016-10-10T12:07:00Z Re: How to Use and Condition in Different Filters in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208867#M23130 <HTML><HEAD></HEAD><BODY><P>Is it possible to allow the user to make "and" operator selection.</P></BODY></HTML> Tue, 11 Oct 2016 11:21:35 GMT https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208867#M23130 Anonymous 2016-10-11T11:21:35Z Re: How to Use and Condition in Different Filters in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208868#M23131 <HTML><HEAD></HEAD><BODY><P>Not sure I follow your question.</P></BODY></HTML> Tue, 11 Oct 2016 11:26:18 GMT https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208868#M23131 sunny_talwar 2016-10-11T11:26:18Z Re: How to Use and Condition in Different Filters in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208869#M23132 <HTML><HEAD></HEAD><BODY><P>Assume we have a list of companies, each company can have activities from the list A, B ,C. </P><P></P><P>Company1 has activities A and B</P><P><SPAN style="font-size: 13.3333px;">Company2 has activities A </SPAN></P><P><SPAN style="font-size: 13.3333px;">Company3 has activities B and C</SPAN></P><P><SPAN style="font-size: 13.3333px;">Company4 has activities <SPAN style="font-size: 13.3333px;">A, B and C</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN><SPAN><SPAN style="font-size: 13.3333px;">now if I have a filter pane and I select A and B,&nbsp; Qlik will count all of the above companies right? since the default behavior of Qlik is OR. Now I'd like to teach the user who to make an "AND" operator selection, so if he/ she selected A and B only Company1 and Company4 should be counted.</SPAN></SPAN></SPAN></P><P><SPAN><SPAN><SPAN><BR /></SPAN></SPAN></SPAN></P><P><SPAN><SPAN><SPAN>Thanks for your help!<BR /></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 11 Oct 2016 11:34:23 GMT https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208869#M23132 Anonymous 2016-10-11T11:34:23Z Re: How to Use and Condition in Different Filters in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208870#M23133 <HTML><HEAD></HEAD><BODY><P>So, a particular filter can allow for either be AND or OR based selection. If you use the method specified in the blog above, you should be able to allow your user to do an AND based selection.</P><P></P><P>This image from the blog shows AND and OR based selection</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/140257_Capture.PNG" style="height: 526px; width: 620px;" /></P><P></P><P>One at top is showing just one bar because its the only one which includes A, B and C skills. Whereas the one at bottom is showing all places where either A or B or C is one of the skills.</P><P></P><P>Does that make sense?</P></BODY></HTML> Tue, 11 Oct 2016 11:39:04 GMT https://community.qlik.com/t5/App-Development/How-to-Use-and-Condition-in-Different-Filters-in-Qlik-Sense/m-p/1208870#M23133 sunny_talwar 2016-10-11T11:39:04Z