topic Re: How to filter the dimension? in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-the-dimension/m-p/1309701#M407258 <HTML><HEAD></HEAD><BODY><P>Hi Adrianus,</P><P></P><P><SPAN style="color: #0000ff; font-size: 10pt;">Sum</SPAN><SPAN style="font-size: 10pt;">({&lt;<SPAN style="color: #800000;">Category</SPAN></SPAN><SPAN style="font-size: 10pt;">-={'Red'}&gt;+&lt;Type-={'Low'}&gt;} Value) </SPAN></P><P><SPAN style="font-size: 10pt;">or </SPAN></P><P><SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Sum</SPAN><SPAN>(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN>(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Category</SPAN><SPAN> &lt;&gt; 'Red',</SPAN><SPAN style="color: #800000; font-size: 8pt;">Value</SPAN><SPAN>,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN>(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Type</SPAN><SPAN> &lt;&gt; 'Low',</SPAN><SPAN style="color: #800000; font-size: 8pt;">Value</SPAN><SPAN>))) </SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN><SPAN><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167206_pastedImage_4.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN><SPAN>Regaards,</SPAN></SPAN></P><P><SPAN><SPAN>Antonio</SPAN></SPAN></P><P></P><P></P></BODY></HTML> Sun, 18 Jun 2017 08:33:02 GMT antoniotiman 2017-06-18T08:33:02Z How to filter the dimension? https://community.qlik.com/t5/QlikView/How-to-filter-the-dimension/m-p/1309700#M407257 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi All,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have field named 'Category' values red, yellow and green and maned 'Type' values high, middle and low. </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Now I put it into Chart dimension, I don't want to show Type low in this dimension if Category is red, how to filter it?</P></BODY></HTML> Sun, 18 Jun 2017 02:40:36 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-dimension/m-p/1309700#M407257 Anonymous 2017-06-18T02:40:36Z Re: How to filter the dimension? https://community.qlik.com/t5/QlikView/How-to-filter-the-dimension/m-p/1309701#M407258 <HTML><HEAD></HEAD><BODY><P>Hi Adrianus,</P><P></P><P><SPAN style="color: #0000ff; font-size: 10pt;">Sum</SPAN><SPAN style="font-size: 10pt;">({&lt;<SPAN style="color: #800000;">Category</SPAN></SPAN><SPAN style="font-size: 10pt;">-={'Red'}&gt;+&lt;Type-={'Low'}&gt;} Value) </SPAN></P><P><SPAN style="font-size: 10pt;">or </SPAN></P><P><SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Sum</SPAN><SPAN>(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN>(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Category</SPAN><SPAN> &lt;&gt; 'Red',</SPAN><SPAN style="color: #800000; font-size: 8pt;">Value</SPAN><SPAN>,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN>(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Type</SPAN><SPAN> &lt;&gt; 'Low',</SPAN><SPAN style="color: #800000; font-size: 8pt;">Value</SPAN><SPAN>))) </SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN><SPAN><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167206_pastedImage_4.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN><SPAN>Regaards,</SPAN></SPAN></P><P><SPAN><SPAN>Antonio</SPAN></SPAN></P><P></P><P></P></BODY></HTML> Sun, 18 Jun 2017 08:33:02 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-dimension/m-p/1309701#M407258 antoniotiman 2017-06-18T08:33:02Z Re: How to filter the dimension? https://community.qlik.com/t5/QlikView/How-to-filter-the-dimension/m-p/1309702#M407259 <HTML><HEAD></HEAD><BODY><P>Thank you Antonio,</P><P>I'll try your formula and inform you the result... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 19 Jun 2017 01:29:34 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-dimension/m-p/1309702#M407259 Anonymous 2017-06-19T01:29:34Z