topic How to filter by 2 dimension same dataset in QlikView

topic How to filter by 2 dimension same dataset in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-by-2-dimension-same-dataset/m-p/104471#M457704 <HTML><HEAD></HEAD><BODY><P>Hi to all i need solution for this kind of problem I have dataset like on example 1</P><P>example1</P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" width="224"><TBODY><TR><TD class="xl65" height="20" width="64">Number</TD><TD class="xl66" style="border-left: none;" width="96">Description</TD><TD class="xl66" style="border-left: none;" width="64">Sales</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">20</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">10</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">30</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">40</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">60</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">31</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">70</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">32</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">80</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">33</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">95</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 7</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">34</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">100</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 8</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">35</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">110</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 9</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">36</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">115</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 10</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">37</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">120</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 11</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">38</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">170</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 12</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">39</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">180</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 13</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">40</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">190</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 14</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">41</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">200</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 15</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">42</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">210</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 16</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">43</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">220</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 17</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">44</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">225</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 18</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">45</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">240</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">46</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">250</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 20</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">47</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">255</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 21</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">48</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">265</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 22</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">49</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">280</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 23</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">50</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">300</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 24</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">51</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">310</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 25</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">52</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">320</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 26</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">53</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">330</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 27</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">54</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">350</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 28</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">55</TD></TR></TBODY></TABLE><P></P><P>I will like to separate in straight table numbers from 20 until 200 in one column and in second column from 210 until 350</P><P>like on example(the first 2 column are dimensions)</P><P></P><P>      </P><TABLE border="0" cellpadding="0" cellspacing="0" width="507"><TBODY><TR><TD class="xl65" height="20" width="68">Number</TD><TD class="xl66" width="96">Description</TD><TD class="xl66" width="96">Sales</TD><TD class="xl65" width="75">Number</TD><TD class="xl66" width="108">Description</TD><TD class="xl68" width="64">Sales</TD></TR><TR><TD align="right" height="20">20</TD><TD class="xl67">Description 1</TD><TD align="right">10</TD><TD align="right">210</TD><TD class="xl67">Description 16</TD><TD align="right">43</TD></TR><TR><TD align="right" height="20">30</TD><TD class="xl67">Description 2</TD><TD align="right">20</TD><TD align="right">220</TD><TD class="xl67">Description 17</TD><TD align="right">44</TD></TR><TR><TD align="right" height="20">40</TD><TD class="xl67">Description 3</TD><TD align="right">30</TD><TD align="right">225</TD><TD class="xl67">Description 18</TD><TD align="right">45</TD></TR><TR><TD align="right" height="20">60</TD><TD class="xl67">Description 4</TD><TD align="right">31</TD><TD align="right">240</TD><TD class="xl67">Description 19</TD><TD align="right">46</TD></TR><TR><TD align="right" height="20">70</TD><TD class="xl67">Description 5</TD><TD align="right">32</TD><TD align="right">250</TD><TD class="xl67">Description 20</TD><TD align="right">47</TD></TR><TR><TD align="right" height="20">80</TD><TD class="xl67">Description 6</TD><TD align="right">33</TD><TD align="right">255</TD><TD class="xl67">Description 21</TD><TD align="right">48</TD></TR><TR><TD align="right" height="20">95</TD><TD class="xl67">Description 7</TD><TD align="right">34</TD><TD align="right">265</TD><TD class="xl67">Description 22</TD><TD align="right">49</TD></TR><TR><TD align="right" class="xl69" height="20">100</TD><TD class="xl67">Description 8</TD><TD align="right">35</TD><TD align="right">280</TD><TD class="xl67">Description 23</TD><TD align="right">50</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">110</TD><TD class="xl67">Description 9</TD><TD align="right">36</TD><TD align="right">300</TD><TD class="xl67">Description 24</TD><TD align="right">51</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">115</TD><TD class="xl67">Description 10</TD><TD align="right">37</TD><TD align="right">310</TD><TD class="xl67">Description 25</TD><TD align="right">52</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">120</TD><TD class="xl67">Description 11</TD><TD align="right">38</TD><TD align="right">320</TD><TD class="xl67">Description 26</TD><TD align="right">53</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">170</TD><TD class="xl67">Description 12</TD><TD align="right">39</TD><TD align="right">330</TD><TD class="xl67">Description 27</TD><TD align="right">54</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">180</TD><TD class="xl67">Description 13</TD><TD align="right">40</TD><TD align="right">350</TD><TD class="xl67">Description 28</TD><TD align="right">55</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">190</TD><TD class="xl67">Description 14</TD><TD align="right">41</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">200</TD><TD class="xl67">Description 15</TD><TD align="right">42</TD></TR></TBODY></TABLE><P></P><P>Thank you</P></BODY></HTML> Fri, 07 Sep 2018 06:33:10 GMT saso_1970 2018-09-07T06:33:10Z How to filter by 2 dimension same dataset https://community.qlik.com/t5/QlikView/How-to-filter-by-2-dimension-same-dataset/m-p/104471#M457704 <HTML><HEAD></HEAD><BODY><P>Hi to all i need solution for this kind of problem I have dataset like on example 1</P><P>example1</P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" width="224"><TBODY><TR><TD class="xl65" height="20" width="64">Number</TD><TD class="xl66" style="border-left: none;" width="96">Description</TD><TD class="xl66" style="border-left: none;" width="64">Sales</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">20</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">10</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">30</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">40</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">60</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">31</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">70</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">32</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">80</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">33</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">95</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 7</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">34</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">100</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 8</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">35</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">110</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 9</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">36</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">115</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 10</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">37</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">120</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 11</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">38</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">170</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 12</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">39</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">180</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 13</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">40</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">190</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 14</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">41</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">200</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 15</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">42</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">210</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 16</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">43</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">220</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 17</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">44</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">225</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 18</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">45</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">240</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">46</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">250</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 20</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">47</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">255</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 21</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">48</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">265</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 22</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">49</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">280</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 23</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">50</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">300</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 24</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">51</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">310</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 25</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">52</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">320</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 26</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">53</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">330</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 27</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">54</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">350</TD><TD class="xl68" style="border-top: none; border-left: none;">Description 28</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">55</TD></TR></TBODY></TABLE><P></P><P>I will like to separate in straight table numbers from 20 until 200 in one column and in second column from 210 until 350</P><P>like on example(the first 2 column are dimensions)</P><P></P><P>      </P><TABLE border="0" cellpadding="0" cellspacing="0" width="507"><TBODY><TR><TD class="xl65" height="20" width="68">Number</TD><TD class="xl66" width="96">Description</TD><TD class="xl66" width="96">Sales</TD><TD class="xl65" width="75">Number</TD><TD class="xl66" width="108">Description</TD><TD class="xl68" width="64">Sales</TD></TR><TR><TD align="right" height="20">20</TD><TD class="xl67">Description 1</TD><TD align="right">10</TD><TD align="right">210</TD><TD class="xl67">Description 16</TD><TD align="right">43</TD></TR><TR><TD align="right" height="20">30</TD><TD class="xl67">Description 2</TD><TD align="right">20</TD><TD align="right">220</TD><TD class="xl67">Description 17</TD><TD align="right">44</TD></TR><TR><TD align="right" height="20">40</TD><TD class="xl67">Description 3</TD><TD align="right">30</TD><TD align="right">225</TD><TD class="xl67">Description 18</TD><TD align="right">45</TD></TR><TR><TD align="right" height="20">60</TD><TD class="xl67">Description 4</TD><TD align="right">31</TD><TD align="right">240</TD><TD class="xl67">Description 19</TD><TD align="right">46</TD></TR><TR><TD align="right" height="20">70</TD><TD class="xl67">Description 5</TD><TD align="right">32</TD><TD align="right">250</TD><TD class="xl67">Description 20</TD><TD align="right">47</TD></TR><TR><TD align="right" height="20">80</TD><TD class="xl67">Description 6</TD><TD align="right">33</TD><TD align="right">255</TD><TD class="xl67">Description 21</TD><TD align="right">48</TD></TR><TR><TD align="right" height="20">95</TD><TD class="xl67">Description 7</TD><TD align="right">34</TD><TD align="right">265</TD><TD class="xl67">Description 22</TD><TD align="right">49</TD></TR><TR><TD align="right" class="xl69" height="20">100</TD><TD class="xl67">Description 8</TD><TD align="right">35</TD><TD align="right">280</TD><TD class="xl67">Description 23</TD><TD align="right">50</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">110</TD><TD class="xl67">Description 9</TD><TD align="right">36</TD><TD align="right">300</TD><TD class="xl67">Description 24</TD><TD align="right">51</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">115</TD><TD class="xl67">Description 10</TD><TD align="right">37</TD><TD align="right">310</TD><TD class="xl67">Description 25</TD><TD align="right">52</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">120</TD><TD class="xl67">Description 11</TD><TD align="right">38</TD><TD align="right">320</TD><TD class="xl67">Description 26</TD><TD align="right">53</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">170</TD><TD class="xl67">Description 12</TD><TD align="right">39</TD><TD align="right">330</TD><TD class="xl67">Description 27</TD><TD align="right">54</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">180</TD><TD class="xl67">Description 13</TD><TD align="right">40</TD><TD align="right">350</TD><TD class="xl67">Description 28</TD><TD align="right">55</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">190</TD><TD class="xl67">Description 14</TD><TD align="right">41</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">200</TD><TD class="xl67">Description 15</TD><TD align="right">42</TD></TR></TBODY></TABLE><P></P><P>Thank you</P></BODY></HTML> Fri, 07 Sep 2018 06:33:10 GMT https://community.qlik.com/t5/QlikView/How-to-filter-by-2-dimension-same-dataset/m-p/104471#M457704 saso_1970 2018-09-07T06:33:10Z