topic Re: How to add square brackets in an expression in QlikView https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358668#M416682 <HTML><HEAD></HEAD><BODY><P>Also, I have not tried this, but this might work as well</P><P></P><P><STRONG><SPAN style="color: #ff0000;">[</SPAN>$(=GetCurrentField([@Cycle]))<SPAN style="color: #ff0000;">]</SPAN></STRONG></P></BODY></HTML> Mon, 26 Jun 2017 13:03:02 GMT sunny_talwar 2017-06-26T13:03:02Z How to add square brackets in an expression https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358666#M416680 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using the following expression with cyclic group called @Cycle</P><P></P><P>AGGR(RANK(SUM({1}[charge-amount])) , $(=GetCurrentField([@Cycle])))</P><P></P><P>However my Fields are called Cust-Name and Charge-Description, so I need to put square brackets around this part of the expression</P><P><SPAN style="font-size: 13.3333px;">$(=GetCurrentField([@Cycle]))</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Can anyone tell me the best way to do it.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Regards</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Alan<BR /></SPAN></P></BODY></HTML> Mon, 26 Jun 2017 12:58:59 GMT https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358666#M416680 rustyfishbones 2017-06-26T12:58:59Z Re: How to add square brackets in an expression https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358667#M416681 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>$(=<SPAN style="color: #ff0000;">'[' &amp;</SPAN> GetCurrentField([@Cycle]) <SPAN style="color: #ff0000;">&amp; ']'</SPAN>)</STRONG></P></BODY></HTML> Mon, 26 Jun 2017 13:02:42 GMT https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358667#M416681 sunny_talwar 2017-06-26T13:02:42Z Re: How to add square brackets in an expression https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358668#M416682 <HTML><HEAD></HEAD><BODY><P>Also, I have not tried this, but this might work as well</P><P></P><P><STRONG><SPAN style="color: #ff0000;">[</SPAN>$(=GetCurrentField([@Cycle]))<SPAN style="color: #ff0000;">]</SPAN></STRONG></P></BODY></HTML> Mon, 26 Jun 2017 13:03:02 GMT https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358668#M416682 sunny_talwar 2017-06-26T13:03:02Z Re: How to add square brackets in an expression https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358669#M416683 <HTML><HEAD></HEAD><BODY><P>Thanks, Both worked</P></BODY></HTML> Mon, 26 Jun 2017 13:08:26 GMT https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358669#M416683 rustyfishbones 2017-06-26T13:08:26Z Re: How to add square brackets in an expression https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358670#M416684 <HTML><HEAD></HEAD><BODY><P>Great, thanks for the confirmation <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 26 Jun 2017 13:09:16 GMT https://community.qlik.com/t5/QlikView/How-to-add-square-brackets-in-an-expression/m-p/1358670#M416684 sunny_talwar 2017-06-26T13:09:16Z