topic removing the certain values in QlikView https://community.qlik.com/t5/QlikView/removing-the-certain-values/m-p/1382148#M808106 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i am having one chart now my question is i want to delete the certain values from the legend.</P><P></P><P>For example i am having some values on the X-axis like 1,2,3,4,5,6. But&nbsp; i dont want the value 1 </P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">How to delete that value or hide? </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT prabhas277 2020-11-25T16:16:04Z removing the certain values https://community.qlik.com/t5/QlikView/removing-the-certain-values/m-p/1382148#M808106 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i am having one chart now my question is i want to delete the certain values from the legend.</P><P></P><P>For example i am having some values on the X-axis like 1,2,3,4,5,6. But&nbsp; i dont want the value 1 </P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">How to delete that value or hide? </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/removing-the-certain-values/m-p/1382148#M808106 prabhas277 2020-11-25T16:16:04Z Re: removing the certain values https://community.qlik.com/t5/QlikView/removing-the-certain-values/m-p/1382149#M808107 <HTML><HEAD></HEAD><BODY><P>You can write something like this</P><P><STRONG>If(Not WildMatch(FieldName,1), FieldName)</STRONG></P><P><STRONG><BR /></STRONG></P><P>Suppress from dimension level</P><P></P><P>OR use set analysis</P><P><STRONG>Sum({&lt;FieldName -= {1}&gt;} Measure)</STRONG></P></BODY></HTML> Tue, 17 Oct 2017 13:16:44 GMT https://community.qlik.com/t5/QlikView/removing-the-certain-values/m-p/1382149#M808107 Anil_Babu_Samineni 2017-10-17T13:16:44Z