topic Re: Ignore selection with a dimension (without using a measure)? in App Development https://community.qlik.com/t5/App-Development/Ignore-selection-with-a-dimension-without-using-a-measure/m-p/1600352#M44388 <P>Include a measure in the table with Set expression e.g.</P><P>Count( {$&lt;Year= &gt;} Customer)</P> Tue, 09 Jul 2019 11:47:31 GMT jfkinspari 2019-07-09T11:47:31Z Ignore selection with a dimension (without using a measure)? https://community.qlik.com/t5/App-Development/Ignore-selection-with-a-dimension-without-using-a-measure/m-p/1600349#M44387 <P>Hello,</P><P>Say I have these two tables:</P><TABLE><TBODY><TR><TD>AddressNumber</TD><TD>Catagory</TD><TD>Customer</TD></TR><TR><TD>200001</TD><TD>10</TD><TD>A</TD></TR><TR><TD>200002</TD><TD>10</TD><TD>B</TD></TR><TR><TD>200003</TD><TD>10</TD><TD>A</TD></TR><TR><TD>200004</TD><TD>20</TD><TD>C</TD></TR><TR><TD>200005</TD><TD>20</TD><TD>D</TD></TR><TR><TD>200006</TD><TD>10</TD><TD>E</TD></TR><TR><TD>200007</TD><TD>40</TD><TD>F</TD></TR><TR><TD>200008</TD><TD>50</TD><TD>G</TD></TR><TR><TD>200009</TD><TD>10</TD><TD>H</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Year</TD><TD>Sales</TD><TD>Customer</TD></TR><TR><TD>2013</TD><TD>500</TD><TD>A</TD></TR><TR><TD>2014</TD><TD>501</TD><TD>B</TD></TR><TR><TD>2015</TD><TD>502</TD><TD>A</TD></TR><TR><TD>2016</TD><TD>234243</TD><TD>C</TD></TR><TR><TD>2017</TD><TD>234244</TD><TD>D</TD></TR><TR><TD>2018</TD><TD>234245</TD><TD>E</TD></TR><TR><TD>2019</TD><TD>234246</TD><TD>F</TD></TR><TR><TD>2020</TD><TD>234247</TD><TD>G</TD></TR><TR><TD>2021</TD><TD>123123</TD><TD>H</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>They are associated via Customer.</P><P>What I want is a straight table that shows all customers even if I select a year in the field year.</P><P>So NOT like this:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="grafik.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/15137iE572A0A09485F684/image-size/large?v=v2&amp;px=999" role="button" title="grafik.png" alt="grafik.png" /></span></P> Sat, 16 Nov 2024 20:29:46 GMT https://community.qlik.com/t5/App-Development/Ignore-selection-with-a-dimension-without-using-a-measure/m-p/1600349#M44387 fzalexanderjohn 2024-11-16T20:29:46Z Re: Ignore selection with a dimension (without using a measure)? https://community.qlik.com/t5/App-Development/Ignore-selection-with-a-dimension-without-using-a-measure/m-p/1600352#M44388 <P>Include a measure in the table with Set expression e.g.</P><P>Count( {$&lt;Year= &gt;} Customer)</P> Tue, 09 Jul 2019 11:47:31 GMT https://community.qlik.com/t5/App-Development/Ignore-selection-with-a-dimension-without-using-a-measure/m-p/1600352#M44388 jfkinspari 2019-07-09T11:47:31Z Re: Ignore selection with a dimension (without using a measure)? https://community.qlik.com/t5/App-Development/Ignore-selection-with-a-dimension-without-using-a-measure/m-p/1600353#M44389 <P>So right now it is not possible to do this without using a measure?</P> Tue, 09 Jul 2019 11:49:32 GMT https://community.qlik.com/t5/App-Development/Ignore-selection-with-a-dimension-without-using-a-measure/m-p/1600353#M44389 fzalexanderjohn 2019-07-09T11:49:32Z