topic Re: Restricting dimensions in QlikView https://community.qlik.com/t5/QlikView/Restricting-dimensions/m-p/1271290#M399913 <HTML><HEAD></HEAD><BODY><P>Or you can use set analysis in your expression</P><P>sum({&lt;Dim={'10E','10C'}&gt;}Value)</P></BODY></HTML> Thu, 17 Nov 2016 22:10:50 GMT stabben23 2016-11-17T22:10:50Z Restricting dimensions https://community.qlik.com/t5/QlikView/Restricting-dimensions/m-p/1271288#M399911 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a dimension with values 10A, 10B, 10C, 10D,10E. Ot of these I want to display only 10E and 10C. I believe I can do this in the calculated Dimension. Can anyone please help me with the syntax??</P></BODY></HTML> Thu, 17 Nov 2016 21:34:03 GMT https://community.qlik.com/t5/QlikView/Restricting-dimensions/m-p/1271288#M399911 2016-11-17T21:34:03Z Re: Restricting dimensions https://community.qlik.com/t5/QlikView/Restricting-dimensions/m-p/1271289#M399912 <HTML><HEAD></HEAD><BODY><P>Try this in your dimension</P><P></P><P>= Pick(Match(Dim, '10E', '10C'), Dim, Dim)</P></BODY></HTML> Thu, 17 Nov 2016 21:44:06 GMT https://community.qlik.com/t5/QlikView/Restricting-dimensions/m-p/1271289#M399912 vishsaggi 2016-11-17T21:44:06Z Re: Restricting dimensions https://community.qlik.com/t5/QlikView/Restricting-dimensions/m-p/1271290#M399913 <HTML><HEAD></HEAD><BODY><P>Or you can use set analysis in your expression</P><P>sum({&lt;Dim={'10E','10C'}&gt;}Value)</P></BODY></HTML> Thu, 17 Nov 2016 22:10:50 GMT https://community.qlik.com/t5/QlikView/Restricting-dimensions/m-p/1271290#M399913 stabben23 2016-11-17T22:10:50Z