topic Variable in a dimension not working :-( in QlikView

Variable in a dimension not working :-(

Mon, 07 Jul 2014 10:24:19 GMT

Hi All,

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

Bob

fkeuroglian — Mon, 07 Jul 2014 11:07:15 GMT

Hi, using macro you have to get and set value from variables, not using =

i put an example

good luck

get value from variable:

set vFromDateTransito = ActiveDocument.Variables("vFromDateTransito")

set value:

set ValorVariable = ActiveDocument.Variables("vTest2")

v = "1"

ValorVariable.SetContent v , true

Mon, 07 Jul 2014 11:16:57 GMT

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

SunilChauhan — Mon, 07 Jul 2014 11:18:39 GMT

use with $ sign

and in dimension use like '$(Variable name)'

Mon, 07 Jul 2014 13:00:58 GMT

How frustratiingly simple - thank you !! 🙂