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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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