topic Re: Concatenating a string and a variable to use a field in QlikView

Concatenating a string and a variable to use a field

paul_hallwood — Tue, 13 May 2014 15:19:40 GMT

I have a variable defined as follows:

SET varData_Status_YEAR = [Year] & '_' & Right(([Year] + 1),2);

I was then hoping to use the value of this variable with a string to select a field to use in a textbox.

e.g. here are the fields that are brought into the Qlikview document whose values I am looking to display:

Data_Status_April_2012_13

Data_Status_April_2013_14

Data_Status_April_2014_15

If I want the value of one of these to be displayed in a text box how do I go about this using the variable varData_Status_YEAR? Is it possible?

I've tried the following to no avail:

=('Data_Status_April_' & $(varData_Status_YEAR))

='Data_Status_April_' & $(varData_Status_YEAR)

...and countless other iterations, but no joy.

If anybody has any suggestions that will be much appreciated.

Re: Concatenating a string and a variable to use a field

Tue, 13 May 2014 15:27:25 GMT

Try in the text object to write this:

= CONCAT ( 'Data_Status_April_'&$(varData_Status_YEAR),' ')

let me know it help you

Re: Concatenating a string and a variable to use a field

Anonymous — Tue, 13 May 2014 15:33:55 GMT

try

='Data_Status_April_' & '$(varData_Status_YEAR)'

Re: Concatenating a string and a variable to use a field

alexandros17 — Tue, 13 May 2014 15:36:22 GMT

The problem is that you have many records with YEAR value so in a text box which one should be displayed?

The concat is a solution but you will see all records in your text box, while I think you need only one value

So write 'Data_Status_April_' & $(varData_Status_YEAR) but select one year ...

Let me know

Re: Concatenating a string and a variable to use a field

paul_hallwood — Tue, 13 May 2014 15:39:40 GMT

Thanks for the reply Matteo, but unfortunately this hasn't worked.

Re: Concatenating a string and a variable to use a field

paul_hallwood — Tue, 13 May 2014 15:41:01 GMT

Unfortunately this hasn't worked either Rudolf.

Re: Concatenating a string and a variable to use a field

paul_hallwood — Tue, 13 May 2014 15:45:49 GMT

Yes, you are quite correct Alessandro, there will be many years to choose from, but I do just choose the one.

Thanks for the suggestion, but it's still causing me an issue!

Any other suggestions welcome...