topic Re: Intersection of Selections issue in QlikView https://community.qlik.com/t5/QlikView/Intersection-of-Selections-issue/m-p/1146863#M889419 <HTML><HEAD></HEAD><BODY><P>Possibly because, you are forcing the selection&nbsp; only for common <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Order_No. If you have to consider the Status too, you have to similarly force the selection for Status as well. That is create another similar action for Status and apply it on the same button click may be.</SPAN></P></BODY></HTML> Tue, 06 Sep 2016 04:42:48 GMT tresB 2016-09-06T04:42:48Z Intersection of Selections issue https://community.qlik.com/t5/QlikView/Intersection-of-Selections-issue/m-p/1146862#M889418 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I am trying to transfer the intersection of selections in Group 1 and Group 2 to a third Group 3 u<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sing alternate states.</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">The button uses the following expression</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">='(' &amp; Concat({Group1 * Group2} Order_No, '|') &amp; ')'</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Question - Why would my pivot table show 'Closed' when I don't have it selected? See image below.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Any help would be greatly appreciated.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P><IMG alt="discussion1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/136490_discussion1.JPG" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Intersection-of-Selections-issue/m-p/1146862#M889418 2020-11-25T16:16:04Z Re: Intersection of Selections issue https://community.qlik.com/t5/QlikView/Intersection-of-Selections-issue/m-p/1146863#M889419 <HTML><HEAD></HEAD><BODY><P>Possibly because, you are forcing the selection&nbsp; only for common <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Order_No. If you have to consider the Status too, you have to similarly force the selection for Status as well. That is create another similar action for Status and apply it on the same button click may be.</SPAN></P></BODY></HTML> Tue, 06 Sep 2016 04:42:48 GMT https://community.qlik.com/t5/QlikView/Intersection-of-Selections-issue/m-p/1146863#M889419 tresB 2016-09-06T04:42:48Z