Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

How to add square brackets in an expression

Hi,

I am using the following expression with cyclic group called @Cycle

AGGR(RANK(SUM({1}[charge-amount])) , $(=GetCurrentField([@Cycle])))

However my Fields are called Cust-Name and Charge-Description, so I need to put square brackets around this part of the expression

$(=GetCurrentField([@Cycle]))


Can anyone tell me the best way to do it.


Regards


Alan

1 Solution

Accepted Solutions
sunny_talwar

May be this

$(='[' & GetCurrentField([@Cycle]) & ']')

View solution in original post

4 Replies
sunny_talwar

May be this

$(='[' & GetCurrentField([@Cycle]) & ']')

sunny_talwar

Also, I have not tried this, but this might work as well

[$(=GetCurrentField([@Cycle]))]

rustyfishbones
Master II
Master II
Author

Thanks, Both worked

sunny_talwar

Great, thanks for the confirmation