topic Create a dimension with a specific string in QlikView https://community.qlik.com/t5/QlikView/Create-a-dimension-with-a-specific-string/m-p/1211369#M873480 <HTML><HEAD></HEAD><BODY><P>I want to create a dimension which filter the string '10PCMARFINAL' from field [Exposure Type]. I should not use SUM, but when I remove sum, I am getting error. What is the correct syntax?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143112_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Create a dimension with a specific string https://community.qlik.com/t5/QlikView/Create-a-dimension-with-a-specific-string/m-p/1211369#M873480 <HTML><HEAD></HEAD><BODY><P>I want to create a dimension which filter the string '10PCMARFINAL' from field [Exposure Type]. I should not use SUM, but when I remove sum, I am getting error. What is the correct syntax?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143112_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Create-a-dimension-with-a-specific-string/m-p/1211369#M873480 2020-11-25T16:16:04Z Re: Create a dimension with a specific string https://community.qlik.com/t5/QlikView/Create-a-dimension-with-a-specific-string/m-p/1211370#M873481 <HTML><HEAD></HEAD><BODY><P>Try =If(Exposure Type]='10PCMARGINAL', [Exposure Type])</P></BODY></HTML> Mon, 07 Nov 2016 14:23:19 GMT https://community.qlik.com/t5/QlikView/Create-a-dimension-with-a-specific-string/m-p/1211370#M873481 Gysbert_Wassenaar 2016-11-07T14:23:19Z Re: Create a dimension with a specific string https://community.qlik.com/t5/QlikView/Create-a-dimension-with-a-specific-string/m-p/1211371#M873482 <HTML><HEAD></HEAD><BODY><P>Give a try with the below: If this doesn't help, then please share a app with sample data and expected output.</P><P></P><P>=Aggr(Only({&lt;[Exposure Type]={'10PCMARGINAL'}&gt;} [<SPAN style="font-size: 13.3333px;">Exposure Type</SPAN>]), Currency,[Discount Curve],[Maturity Bucket].[Trade ID])</P><P></P><P>Note: you need to list all your dimensions at the end in the above expression.</P></BODY></HTML> Mon, 07 Nov 2016 14:28:48 GMT https://community.qlik.com/t5/QlikView/Create-a-dimension-with-a-specific-string/m-p/1211371#M873482 trdandamudi 2016-11-07T14:28:48Z