topic Re: Hide rows based on data values in QlikView https://community.qlik.com/t5/QlikView/Hide-rows-based-on-data-values/m-p/940933#M966329 <HTML><HEAD></HEAD><BODY><P>I found solution, you can use</P><P>=IF(not match(ABC,1,2),ABC)</P><P>and check the box which says 'suppress when value is null'</P></BODY></HTML> Mon, 28 Sep 2015 16:41:44 GMT ashishpalkar 2015-09-28T16:41:44Z Hide rows based on data values https://community.qlik.com/t5/QlikView/Hide-rows-based-on-data-values/m-p/940930#M966326 <HTML><HEAD></HEAD><BODY><P>Hi There</P><P></P><P>I have created table , i want to hide rows when values are Item1=North , Item2=East (item1 and item2 are columns in the table)</P><P></P><P>Thanks in advance. </P></BODY></HTML> Fri, 25 Sep 2015 14:27:58 GMT https://community.qlik.com/t5/QlikView/Hide-rows-based-on-data-values/m-p/940930#M966326 ashishpalkar 2015-09-25T14:27:58Z Re: Hide rows based on data values https://community.qlik.com/t5/QlikView/Hide-rows-based-on-data-values/m-p/940931#M966327 <HTML><HEAD></HEAD><BODY><P>Assuming it is a Straight Table [Chart], then use Set Analysis in the expression<S>.</S></P><P></P><P>On this site search for<EM> Set Analysis</EM> and you'll get loads of hits.</P></BODY></HTML> Fri, 25 Sep 2015 14:34:53 GMT https://community.qlik.com/t5/QlikView/Hide-rows-based-on-data-values/m-p/940931#M966327 Anonymous 2015-09-25T14:34:53Z Re: Hide rows based on data values https://community.qlik.com/t5/QlikView/Hide-rows-based-on-data-values/m-p/940932#M966328 <HTML><HEAD></HEAD><BODY><P>Hi Thanks for the info, can you send QVW file with sample example. </P></BODY></HTML> Mon, 28 Sep 2015 15:19:33 GMT https://community.qlik.com/t5/QlikView/Hide-rows-based-on-data-values/m-p/940932#M966328 ashishpalkar 2015-09-28T15:19:33Z Re: Hide rows based on data values https://community.qlik.com/t5/QlikView/Hide-rows-based-on-data-values/m-p/940933#M966329 <HTML><HEAD></HEAD><BODY><P>I found solution, you can use</P><P>=IF(not match(ABC,1,2),ABC)</P><P>and check the box which says 'suppress when value is null'</P></BODY></HTML> Mon, 28 Sep 2015 16:41:44 GMT https://community.qlik.com/t5/QlikView/Hide-rows-based-on-data-values/m-p/940933#M966329 ashishpalkar 2015-09-28T16:41:44Z