topic Re: where clause in expression in QlikView https://community.qlik.com/t5/QlikView/where-clause-in-expression/m-p/253356#M96025 <HTML><HEAD></HEAD><BODY><P>thnks alot swuehl !!!</P><P>thats perfect and quick ....</P><P>further i want to know can i get the same with regular expression???</P></BODY></HTML> Thu, 05 Jan 2012 10:17:14 GMT 2012-01-05T10:17:14Z where clause in expression https://community.qlik.com/t5/QlikView/where-clause-in-expression/m-p/253354#M96023 <HTML><HEAD></HEAD><BODY><P>i m new to qlikview and its my fist post......... hope i will get the solution</P><P></P><P>I have a bar chart with ITEM_NAME as dimension and SUM(QUANTIT) as expression </P><P>I want to show the unit of item in text box....</P><P>i.e </P><P>If user select any particular item from list box so apropriate unit of that item (may be more then one (e.g water can be in Liter or bottols) display on text box or any other way to do this...?</P><P>thnks alot</P></BODY></HTML> Thu, 05 Jan 2012 09:32:59 GMT https://community.qlik.com/t5/QlikView/where-clause-in-expression/m-p/253354#M96023 2012-01-05T09:32:59Z where clause in expression https://community.qlik.com/t5/QlikView/where-clause-in-expression/m-p/253355#M96024 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>= if( GetSelectedCount(ITEM_NAME) = 1,</P><P>'Units of '&amp; ITEM_NAME&amp;' are: '&amp; concat (distinct UNIT_NAME,' - ') </P><P>)</P></BODY></HTML> Thu, 05 Jan 2012 09:37:53 GMT https://community.qlik.com/t5/QlikView/where-clause-in-expression/m-p/253355#M96024 swuehl 2012-01-05T09:37:53Z Re: where clause in expression https://community.qlik.com/t5/QlikView/where-clause-in-expression/m-p/253356#M96025 <HTML><HEAD></HEAD><BODY><P>thnks alot swuehl !!!</P><P>thats perfect and quick ....</P><P>further i want to know can i get the same with regular expression???</P></BODY></HTML> Thu, 05 Jan 2012 10:17:14 GMT https://community.qlik.com/t5/QlikView/where-clause-in-expression/m-p/253356#M96025 2012-01-05T10:17:14Z where clause in expression https://community.qlik.com/t5/QlikView/where-clause-in-expression/m-p/253357#M96026 <HTML><HEAD></HEAD><BODY><P>Hm, can you give an example in pseudo code what you intend to do?</P></BODY></HTML> Thu, 05 Jan 2012 10:28:00 GMT https://community.qlik.com/t5/QlikView/where-clause-in-expression/m-p/253357#M96026 swuehl 2012-01-05T10:28:00Z