Discussion Board for collaboration related to QlikView App Development.
I have a dimension.. where vThisWeek is a variable
if (SalesWeek= vThisWeek,'Yes')
which works fine, but then I want to change it using a macro and hence want to use another variable i.e.
vReportNeeded = vThisWeek OR SalesWeek = vLastWeek
and then have if( SalesWeek=vReportNeeded, 'Yes') but it doesn't seem to work and produces no figures.
I ant to throw various week values at it, hence the variable
Anyone any ideas please ?
Thanks in advance
use with $ sign
and in dimension use like '$(Variable name)'
View solution in original post
Hi, using macro you have to get and set value from variables, not using =
i put an example
get value from variable:
set vFromDateTransito = ActiveDocument.Variables("vFromDateTransito")
set ValorVariable = ActiveDocument.Variables("vTest2")
v = "1"
ValorVariable.SetContent v , true
Hi thanks for the reply but it does nto help I am afraid.
I have a macro that sets the variable, but after it has set the variable the dimnesion will still not produce figures from it
How frustratiingly simple - thank you !! 🙂