topic Re: Use variable within brackets in an expression in QlikView

Use variable within brackets in an expression

mahmad — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm trying to figure out how to dynamically change text within brackets (variable name within an expression). I have a variable that a user can determine with a dropdown, and this can be either X or Y. I would like to use this value to populate the expressions below:

Aggr(Min({$<[Year] = >}[First Year X]),[%ID])

Aggr(Min({$<[Year] = >}[First Year Y]),[%ID])

I would like to replace X or Y with a variable, but am not sure about the syntax; something like "[First Year " & variable & "]" would be great.

Thanks!

Re: Use variable within brackets in an expression

_ylc — Mon, 02 Mar 2020 01:23:10 GMT

Create your variable for X and Y. Let's call it vTest. Then your formula will be something like this:

=Min($(='[First Year '&'$(vTest)'&']'))

Re: Use variable within brackets in an expression

mahmad — Mon, 02 Mar 2020 01:31:18 GMT

This worked beautifully - thanks!