topic Qlik - Flag to filter out dimension based on occurrence in App Development https://community.qlik.com/t5/App-Development/Qlik-Flag-to-filter-out-dimension-based-on-occurrence/m-p/2533797#M108283 <P>Hi All,</P> <P>I have a data set like below</P> <TABLE width="370"> <TBODY> <TR> <TD width="94">YearMonth</TD> <TD width="64">Product</TD> <TD width="84">SubProduct</TD> <TD width="64">SalesMan</TD> <TD width="64">Count</TD> </TR> <TR> <TD>Jan-25</TD> <TD>Car</TD> <TD>Tire</TD> <TD>John</TD> <TD>20</TD> </TR> <TR> <TD>Jan-25</TD> <TD>TV</TD> <TD>Remote</TD> <TD>Jason</TD> <TD>25</TD> </TR> <TR> <TD>Jan-25</TD> <TD>Fridge</TD> <TD>filter</TD> <TD>John</TD> <TD>34</TD> </TR> <TR> <TD>Feb-25</TD> <TD>Car</TD> <TD>Tire</TD> <TD>John</TD> <TD>20</TD> </TR> <TR> <TD>Feb-25</TD> <TD>TV</TD> <TD>Remote</TD> <TD>Jason</TD> <TD>56</TD> </TR> <TR> <TD>Feb-25</TD> <TD>Car</TD> <TD>Seats</TD> <TD>Aaron</TD> <TD>36</TD> </TR> <TR> <TD>Mar-25</TD> <TD>TV</TD> <TD>Remote</TD> <TD>Jason</TD> <TD>37</TD> </TR> <TR> <TD>Mar-25</TD> <TD>Fridge</TD> <TD>filter</TD> <TD>John</TD> <TD>38</TD> </TR> <TR> <TD>Mar-25</TD> <TD>Car</TD> <TD>Tire</TD> <TD>Aaron</TD> <TD>39</TD> </TR> <TR> <TD>Apr-25</TD> <TD>TV</TD> <TD>Remote</TD> <TD>John</TD> <TD>40</TD> </TR> <TR> <TD>Apr-25</TD> <TD>Car</TD> <TD>Tire</TD> <TD>Mark</TD> <TD>42</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>When I select Fridge, I should be able to show in table on frontend where in Feb2025, Apr-25 John dint do any sales for Fridge, same when I select TV I should be able to show Jason dint do any sales in Apr,2025 etc</P> <P>Also, when I select Tire, i should be able to show in a table in front end where in Mar 2025 and Apr 2025 John dint do any sales, and when i select Remote - Jason dint do any sales in Apr 2025.</P> <P>&nbsp;</P> <P>Can anyone please help me to achieve this?</P> <P>&nbsp;</P> <P>Thanks in Advance!</P> Sun, 19 Oct 2025 22:15:43 GMT Shivam22 2025-10-19T22:15:43Z Qlik - Flag to filter out dimension based on occurrence https://community.qlik.com/t5/App-Development/Qlik-Flag-to-filter-out-dimension-based-on-occurrence/m-p/2533797#M108283 <P>Hi All,</P> <P>I have a data set like below</P> <TABLE width="370"> <TBODY> <TR> <TD width="94">YearMonth</TD> <TD width="64">Product</TD> <TD width="84">SubProduct</TD> <TD width="64">SalesMan</TD> <TD width="64">Count</TD> </TR> <TR> <TD>Jan-25</TD> <TD>Car</TD> <TD>Tire</TD> <TD>John</TD> <TD>20</TD> </TR> <TR> <TD>Jan-25</TD> <TD>TV</TD> <TD>Remote</TD> <TD>Jason</TD> <TD>25</TD> </TR> <TR> <TD>Jan-25</TD> <TD>Fridge</TD> <TD>filter</TD> <TD>John</TD> <TD>34</TD> </TR> <TR> <TD>Feb-25</TD> <TD>Car</TD> <TD>Tire</TD> <TD>John</TD> <TD>20</TD> </TR> <TR> <TD>Feb-25</TD> <TD>TV</TD> <TD>Remote</TD> <TD>Jason</TD> <TD>56</TD> </TR> <TR> <TD>Feb-25</TD> <TD>Car</TD> <TD>Seats</TD> <TD>Aaron</TD> <TD>36</TD> </TR> <TR> <TD>Mar-25</TD> <TD>TV</TD> <TD>Remote</TD> <TD>Jason</TD> <TD>37</TD> </TR> <TR> <TD>Mar-25</TD> <TD>Fridge</TD> <TD>filter</TD> <TD>John</TD> <TD>38</TD> </TR> <TR> <TD>Mar-25</TD> <TD>Car</TD> <TD>Tire</TD> <TD>Aaron</TD> <TD>39</TD> </TR> <TR> <TD>Apr-25</TD> <TD>TV</TD> <TD>Remote</TD> <TD>John</TD> <TD>40</TD> </TR> <TR> <TD>Apr-25</TD> <TD>Car</TD> <TD>Tire</TD> <TD>Mark</TD> <TD>42</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>When I select Fridge, I should be able to show in table on frontend where in Feb2025, Apr-25 John dint do any sales for Fridge, same when I select TV I should be able to show Jason dint do any sales in Apr,2025 etc</P> <P>Also, when I select Tire, i should be able to show in a table in front end where in Mar 2025 and Apr 2025 John dint do any sales, and when i select Remote - Jason dint do any sales in Apr 2025.</P> <P>&nbsp;</P> <P>Can anyone please help me to achieve this?</P> <P>&nbsp;</P> <P>Thanks in Advance!</P> Sun, 19 Oct 2025 22:15:43 GMT https://community.qlik.com/t5/App-Development/Qlik-Flag-to-filter-out-dimension-based-on-occurrence/m-p/2533797#M108283 Shivam22 2025-10-19T22:15:43Z Re: Qlik - Flag to filter out dimension based on occurrence https://community.qlik.com/t5/App-Development/Qlik-Flag-to-filter-out-dimension-based-on-occurrence/m-p/2533802#M108284 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/351984">@Shivam22</a>&nbsp;</P><P>How about this?</P><P>This case Modelling is required.</P><P>First, I make a master table for YearMonth, products, sub-products, and salesman .</P><P>And I joined the sales information you presented.</P><P>&nbsp;</P><P><FONT face="arial black,avant garde">[unselect]</FONT>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hanna_choi_1-1760925871146.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/184321i0D2F6693BFC23859/image-size/large?v=v2&amp;px=999" role="button" title="hanna_choi_1-1760925871146.png" alt="hanna_choi_1-1760925871146.png" /></span></P><P>&nbsp;</P><P><FONT face="arial black,avant garde" color="#0000FF">[select]</FONT>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hanna_choi_0-1760925840997.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/184320iABA35C8E27F871A0/image-size/large?v=v2&amp;px=999" role="button" title="hanna_choi_0-1760925840997.png" alt="hanna_choi_0-1760925840997.png" /></span></P><P>&nbsp;</P><P><FONT color="#FF0000">[Data Load Editor]</FONT></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hanna_choi_2-1760925963432.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/184322i27F1BD4206CAAAAD/image-size/large?v=v2&amp;px=999" role="button" title="hanna_choi_2-1760925963432.png" alt="hanna_choi_2-1760925963432.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 20 Oct 2025 02:08:00 GMT https://community.qlik.com/t5/App-Development/Qlik-Flag-to-filter-out-dimension-based-on-occurrence/m-p/2533802#M108284 hanna_choi 2025-10-20T02:08:00Z