topic Changing Hardcoded in variable in QlikView

ChangeHardcoded in variable

Wed, 22 Sep 2010 15:45:43 GMT

=((

SUM({1<Budgetscheiding ={'Detailhandel'}>} AantalHuidigJaar)-SUM({1<Budgetscheiding ={'Detailhandel'}>}AantalHuidigJaarMin1))/SUM({1<Budgetscheiding ={'Detailhandel'}>}AantalHuidigJaarMin1

))

How can i change te hardcoded words Detailhandel in the Variable test.

Thanks,

Changing Hardcoded in variable

Wed, 22 Sep 2010 15:51:42 GMT

Are you trying to create a variable test and use that to store the desired value for Budgetscheiding?

Is so, create the variable and give it a value. Then use:


=((SUM({1<Budgetscheiding ={'$(Test)'}>} AantalHuidigJaar)-
SUM({1<Budgetscheiding ={'$(Test)'}>}AantalHuidigJaarMin1))/
SUM({1<Budgetscheiding ={'$(Test)'}>}AantalHuidigJaarMin1
))

Changing Hardcoded in variable

Wed, 22 Sep 2010 16:02:25 GMT

Thanks for the quick reply.

Greetz,

Dirk