topic Variable Issues in QlikView

Variable Issues

Mon, 07 Jan 2013 10:42:01 GMT

Hi,

First a bit of background information;

I have made a button based on if they click it it will show either gross premium or net premium. so therefore I needed to change the fields inside of the tables and chart etc so that it looks at this variable to see if it selected and then shows the appropriate premium figure.

However I am having some issues when I am putting this variable in a formula. All I have done is changed the formula that was already there with the new variable that I have created which should pick up which premium figure is selected.

Could anyone advise what may be the problem?

Many thanks,

Re: Variable Issues

Anonymous — Mon, 07 Jan 2013 12:32:48 GMT

Do you mean that this variable sets the field name used in an expression. If so, you will need the dollar expansion, like this:

sum($(TheFieldName))

Jonathan

Re: Variable Issues

Mon, 07 Jan 2013 12:39:01 GMT

Pls post ur sample..

Re: Variable Issues

Mon, 07 Jan 2013 12:39:14 GMT

Thanks for your response Jonathan but I have tried that and it didnt seem to make any difference.