topic Using variable information in Label in QlikView

Using variable information in Label

Mon, 30 Jun 2014 21:05:06 GMT

I have created a variable called vBegDate and it looks like this in my load:

LET vBegDate = Num(makedate(year(Today()),1,1));

I have to use the first day of the first month for each year to do comparisons.

I would like to use this variable in a label that would say 'Beginning Value as of _________ (put the variable date here)

Is this possible to do????

Re: Using variable information in Label

vgutkovsky — Mon, 30 Jun 2014 21:28:10 GMT

Sure! You would just need to preface the text label with an equal sign to indicate that it's an expression:

='Beginning value as of ' & vBegDate

Regards,

Vlad

Re: Using variable information in Label

Tue, 01 Jul 2014 00:34:36 GMT

Vlad Gutkovsky is correct. In addition you may want to wrap the vBegDate variable in the Date() function to get a formatted date instead of the date numeric number.

Examples:

='Beginning value as of ' & Date(vBegDate)

='Beginning value as of ' & Date(vBegDate, 'MM/DD/YYYY')