topic Different values between variables and formulas in QlikView

Different values between variables and formulas

Tue, 28 Jul 2015 14:15:56 GMT

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?

Re: Different values between variables and formulas

lironbaram — Tue, 28 Jul 2015 14:24:58 GMT

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

Re: Different values between variables and formulas

Tue, 28 Jul 2015 14:29:12 GMT

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

Re: Different values between variables and formulas

lironbaram — Tue, 28 Jul 2015 14:34:05 GMT

in the expression you need to put $(variablename)

Re: Different values between variables and formulas

Tue, 28 Jul 2015 15:10:25 GMT

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