topic Re: Variable definition now shows value instead of expression in QlikView

Variable definition now shows value instead of expression

alanmcgrath — Wed, 13 Jul 2016 19:16:45 GMT

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.

Re: Variable definition now shows value instead of expression

rwunderlich — Wed, 13 Jul 2016 20:51:03 GMT

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.

-Rob

Re: Variable definition now shows value instead of expression

alanmcgrath — Thu, 14 Jul 2016 12:33:53 GMT

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.

Re: Variable definition now shows value instead of expression

Thu, 14 Jul 2016 13:22:54 GMT

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.

Re: Variable definition now shows value instead of expression

alanmcgrath — Thu, 14 Jul 2016 13:54:51 GMT

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.

Re: Variable definition now shows value instead of expression

rwunderlich — Thu, 14 Jul 2016 14:07:23 GMT

It does indeed look like the variable is getting evaluated. Are the variables mentioned in the script at all? What version and SR of QV are you using?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Variable definition now shows value instead of expression

alanmcgrath — Thu, 14 Jul 2016 14:13:01 GMT

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

Re: Variable definition now shows value instead of expression

Mark_Little — Thu, 14 Jul 2016 14:16:08 GMT

Hi,

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.

Mark

Re: Variable definition now shows value instead of expression

alanmcgrath — Thu, 14 Jul 2016 14:29:10 GMT

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?

Re: Variable definition now shows value instead of expression

rwunderlich — Thu, 14 Jul 2016 15:23:25 GMT

Are you setting the variables with an action? Perhaps in the OnOpen trigger?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Variable definition now shows value instead of expression

Anonymous — Thu, 14 Jul 2016 15:29:06 GMT

Can you share your script with everyone? As you mention it is after the reload that the variable definitions have been replaced by values so that does point to something in the script causing this although I note you mentioning you don't reference these variables in the load script. It seems very strange indeed.

Re: Variable definition now shows value instead of expression

alanmcgrath — Thu, 14 Jul 2016 16:12:35 GMT

I've exported the script and posted to the original message. The only thing not there is the hidden script for the section access. Thanks!

Re: Variable definition now shows value instead of expression

swuehl — Thu, 14 Jul 2016 16:49:45 GMT

I vaguely remember some pretty old discussions that reported similar, like for example

Lost of variable content

(I think there were some few more discussions, but couldn't find it right now).

Do you have any backups of your application that still show the variables (if so, there are methods to export and import the variables into your latest version)?

Re: Variable definition now shows value instead of expression

alanmcgrath — Thu, 14 Jul 2016 16:52:18 GMT

Yes I have an older version from a few months back. How can I export from there an import into the latest?

Re: Variable definition now shows value instead of expression

swuehl — Thu, 14 Jul 2016 17:04:44 GMT

For example like shown here

Importing and exporting variables - The Qlik Fix! The Qlik Fix!

Re: Variable definition now shows value instead of expression

alanmcgrath — Thu, 14 Jul 2016 17:31:57 GMT

Thanks!! This is going to be a life saver!

Re: Variable definition now shows value instead of expression

rwunderlich — Thu, 14 Jul 2016 20:34:02 GMT

We'll be curious to know if the problem returns after the next reload. Let us know.

-Rob

Re: Variable definition now shows value instead of expression

alanmcgrath — Fri, 15 Jul 2016 12:34:35 GMT

Well the import of the variables worked fine for my copy on my laptop but once I deploy to the server it is still not working as expected; When I apply the filters, the metrics are not updating as they should. I'm hoping that moving the variables into the script and reloading will fix the problem. Is it a better practice to put variables in the script than in the variable overview?

Re: Variable definition now shows value instead of expression

swuehl — Fri, 15 Jul 2016 15:30:19 GMT

When I apply the filters, the metrics are not updating as they should.

They don't update at all or they do, but showing unexpected results?

Re: Variable definition now shows value instead of expression

alanmcgrath — Fri, 15 Jul 2016 15:31:39 GMT

They don't update at all