topic Re: Create Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Create-Calculated-Dimension/m-p/364180#M135500 <HTML><HEAD></HEAD><BODY><P>Or you can try</P><P></P><P>=If( NivelLike 'Total*', Nivel, Null())</P></BODY></HTML> Tue, 22 May 2012 19:34:35 GMT oscar_ortiz 2012-05-22T19:34:35Z Create Calculated Dimension https://community.qlik.com/t5/QlikView/Create-Calculated-Dimension/m-p/364178#M135498 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a current "dimension" called NIVEL with several elements as shown:</P><P></P><P><IMG alt="YES YO.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/14634_YES+YO.bmp" /></P><P></P><P>Now I want to create a bar chart with a CALCULATED DIMENSION but including ONLY the GREEN shaded elements.</P><P></P><P>How can I accomplish this??</P></BODY></HTML> Tue, 22 May 2012 19:26:23 GMT https://community.qlik.com/t5/QlikView/Create-Calculated-Dimension/m-p/364178#M135498 2012-05-22T19:26:23Z Create Calculated Dimension https://community.qlik.com/t5/QlikView/Create-Calculated-Dimension/m-p/364179#M135499 <HTML><HEAD></HEAD><BODY><P>if you want to use a calculated dimension, maybe like</P><P></P><P><EM>=if( wildmatch( Nivel, 'Total*'), Nivel)</EM></P></BODY></HTML> Tue, 22 May 2012 19:30:18 GMT https://community.qlik.com/t5/QlikView/Create-Calculated-Dimension/m-p/364179#M135499 swuehl 2012-05-22T19:30:18Z Re: Create Calculated Dimension https://community.qlik.com/t5/QlikView/Create-Calculated-Dimension/m-p/364180#M135500 <HTML><HEAD></HEAD><BODY><P>Or you can try</P><P></P><P>=If( NivelLike 'Total*', Nivel, Null())</P></BODY></HTML> Tue, 22 May 2012 19:34:35 GMT https://community.qlik.com/t5/QlikView/Create-Calculated-Dimension/m-p/364180#M135500 oscar_ortiz 2012-05-22T19:34:35Z