I have a QVW where I have set several variables in the variable overview. All of these I set as expressions. This has worked fine for the past several months but this month when I reloaded the data the variables now just show the value and no longer the expression. Has anyone had this happen before and know how to fix it? I did not change any script so no clue as to why this happened and now the qvw is not working properly.
Are your variables defined in the Script? It sounds like they are being created in the script with a LET statement instead of a SET statement.
I set all the expressions in the variable overview. For example one of my variables was
=If(vLeaverToggle=1 and vYOYAChart=1 and vMngdRadio=1,1,0) .
Now after the reload is shows the value of 1 in the variable overview. I'm not sure if some setting changed or what happened.
What is the purpose of the expression?
i would think that the vLeaverToggle, vYOYAChart, VMngdRadio are indeed for the variable overview, but the expression itself could be used in the chart (?) that you are using.
This particular expression sets the value as 1 or 0 for the variable vHeader. So it works as a conditional show based on selections made within the QVW. This is just one of over a hundred variables that perform various functions that I have set in the Variable Overview section. Each one that had an expression within the definition section no longer shows that expression but rather the resulting value. This happened after I reloaded the data this month. Before that there was no issue. I need to get those expressions back so they will calculate properly because as of right now it is as if everything has been hard coded.
The variables I have set in the variable overview are not referenced in the script. I do have some variables in the script but those are related to the master calendar and for ranges. I'm on version 11.20.12904.0 SR 12
Like Rob says the expressions are being evaluated,
Were they just typed in the variable overview.
A quick way to prove this, try removing the = at the start and see if this corrects the issue.
Yes the expression was typed in the variable overview definition but now the expression is not there at all. it only shows the value. So it is as if it evaluated the expression and then replaced the expression with the value.
I'm trying to figure out how the expressions disappeared and how to get them back. Example below:
Here is a view of the variable overview from an old version of my report. You can see here the expression for the variable vAvailable. You can also see others there in the list. Now see 2nd image...
As you can see here (below) in my latest version, these expression are now gone and replaced by the numbers. Any idea how this happened and how I can get the expressions back without rewriting each one?