Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variable Issues

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,

3 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

Pls post ur sample..

Not applicable
Author

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