Discussion Board for collaboration related to QlikView App Development.
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:
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.
Try in the text object to write this:
= CONCAT ( 'Data_Status_April_'&$(varData_Status_YEAR),' ')
let me know it help you
='Data_Status_April_' & '$(varData_Status_YEAR)'
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
Thanks for the reply Matteo, but unfortunately this hasn't worked.
Unfortunately this hasn't worked either Rudolf.
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...