Different values between variables and formulas

[#1]

I'm populating variables via a database, but when I use the variable in either a chart(pie chart) or a pivot table, the value the variable gives is the Total for the selection. If I put the formula is a cell by itself, it brings back the correct value, when it's places in a chart, it brings back the total. If I take the formula associated with the variable, and place the formula directly into the pivot table, it works correctly.

any idea why using the variable name would show the total when used in a chart or pivot table?

[lironbaram]

when using formulas inside variables

you should note this behavior

if there is a '=' sign in the variable formula the variable will return the formula total result

if there isn't a 'Sign' then the variable formula will be calculated at each cell

[#3]

I figured that was the issue, but wether or not I put an "=" in the expression box, the total is returned. In my database, I use the "=". In QlikView expression, if I put VariableName I get the total, and if I put =VariableName I get the total

[lironbaram · Accepted solution]

in the expression you need to put $(variablename)

[#5]

I removed the = from the database and made the expressions =$(variable) and it worked. Thanks for your help!