topic exclude selection in bar chart in QlikView https://community.qlik.com/t5/QlikView/exclude-selection-in-bar-chart/m-p/1358497#M843764 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="424" style="border: 1px solid rgb(0, 0, 0); width: 107px; height: 393px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Transportation</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Car</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Bike</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Bus</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Cycle</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Ship</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Car</SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Bus</SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">Airplane</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Car</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Bus</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Airplane</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Ship</SPAN></TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Cycle</SPAN></TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Car</SPAN></TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">Helicopter</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">Boat</TD></TR></TBODY></TABLE><P></P><P>when I click B from ID list box </P><P>its related Transportation is Car,&nbsp; Bus, <SPAN style="font-size: 13.3333px;">Airplane</SPAN></P><P></P><P>but business user need bar chart like</P><P></P><P>A=2 <SPAN style="color: #575757;"> (because it have </SPAN><SPAN style="font-size: 13.3333px;"><SPAN style="color: #575757;">Car and </SPAN><SPAN style="color: #575757; font-size: 13.3333px;">Bus)</SPAN></SPAN></P><P>C=3 <SPAN style="font-size: 13.3333px;"> (because it have </SPAN><SPAN style="font-size: 13.3333px;">Car, <SPAN style="color: #575757; font-size: 13.3333px;">Bus, <SPAN style="font-size: 13.3333px;">Airplane</SPAN>)</SPAN></SPAN></P><P>D=1&nbsp; <SPAN style="font-size: 13.3333px;"> (because it have </SPAN><SPAN style="font-size: 13.3333px;">Car<SPAN style="color: #575757; font-size: 13.3333px;">Bus)</SPAN></SPAN></P><P></P><P></P><P>Note:</P><P>I can't use Cross Table for this because it affect Data model </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT vengadeshpalani 2020-11-25T16:16:04Z exclude selection in bar chart https://community.qlik.com/t5/QlikView/exclude-selection-in-bar-chart/m-p/1358497#M843764 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="424" style="border: 1px solid rgb(0, 0, 0); width: 107px; height: 393px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Transportation</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Car</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Bike</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Bus</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Cycle</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Ship</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Car</SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Bus</SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">Airplane</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Car</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Bus</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Airplane</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Ship</SPAN></TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Cycle</SPAN></TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Car</SPAN></TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">Helicopter</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">Boat</TD></TR></TBODY></TABLE><P></P><P>when I click B from ID list box </P><P>its related Transportation is Car,&nbsp; Bus, <SPAN style="font-size: 13.3333px;">Airplane</SPAN></P><P></P><P>but business user need bar chart like</P><P></P><P>A=2 <SPAN style="color: #575757;"> (because it have </SPAN><SPAN style="font-size: 13.3333px;"><SPAN style="color: #575757;">Car and </SPAN><SPAN style="color: #575757; font-size: 13.3333px;">Bus)</SPAN></SPAN></P><P>C=3 <SPAN style="font-size: 13.3333px;"> (because it have </SPAN><SPAN style="font-size: 13.3333px;">Car, <SPAN style="color: #575757; font-size: 13.3333px;">Bus, <SPAN style="font-size: 13.3333px;">Airplane</SPAN>)</SPAN></SPAN></P><P>D=1&nbsp; <SPAN style="font-size: 13.3333px;"> (because it have </SPAN><SPAN style="font-size: 13.3333px;">Car<SPAN style="color: #575757; font-size: 13.3333px;">Bus)</SPAN></SPAN></P><P></P><P></P><P>Note:</P><P>I can't use Cross Table for this because it affect Data model </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/exclude-selection-in-bar-chart/m-p/1358497#M843764 vengadeshpalani 2020-11-25T16:16:04Z Re: exclude selection in bar chart https://community.qlik.com/t5/QlikView/exclude-selection-in-bar-chart/m-p/1358498#M843765 <HTML><HEAD></HEAD><BODY><P>Find the attached application. Do you want something like this?</P></BODY></HTML> Fri, 07 Apr 2017 01:41:06 GMT https://community.qlik.com/t5/QlikView/exclude-selection-in-bar-chart/m-p/1358498#M843765 Siva_Sankar 2017-04-07T01:41:06Z Re: exclude selection in bar chart https://community.qlik.com/t5/QlikView/exclude-selection-in-bar-chart/m-p/1358499#M843766 <HTML><HEAD></HEAD><BODY><P>May be this (using <A href="https://community.qlik.com/people/shankarece">shankarece</A>‌'s attached sample)</P><P><STRONG>Count({&lt;ID = E(ID), Transportation = P(Transportation)&gt;}Transportation)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159393_Capture.PNG" style="height: 404px; width: 620px;" /></P></BODY></HTML> Fri, 07 Apr 2017 08:20:52 GMT https://community.qlik.com/t5/QlikView/exclude-selection-in-bar-chart/m-p/1358499#M843766 sunny_talwar 2017-04-07T08:20:52Z Re: exclude selection in bar chart https://community.qlik.com/t5/QlikView/exclude-selection-in-bar-chart/m-p/1358500#M843767 <HTML><HEAD></HEAD><BODY><P>u always awesome </P><P>Thank You Sunny....... </P></BODY></HTML> Fri, 07 Apr 2017 13:47:25 GMT https://community.qlik.com/t5/QlikView/exclude-selection-in-bar-chart/m-p/1358500#M843767 vengadeshpalani 2017-04-07T13:47:25Z