topic Re: Different results using same formula (table x script variable) in QlikView

Different results using same formula (table x script variable)

h_demarco — Fri, 06 Jan 2017 19:36:55 GMT

Dear all,

I am having some difficult to understand why a formula assinged to variable in script is not returning the same result as formula wrote directly in a table.

So my table is:

[Tempo Calendario] is =Sum(Duração_turno)

[Tempo Calendario2] is tempo_calendario (variable)

in script I have

Set tempo_calendario= =Sum(Duração_turno);

I'd like to get [Tempo Calendario] result, but with variable assign because the same formula is used many times. Variable will save my time upon any change.

Any idea on how to handle this?

Thanks in advance.

Henrique

Re: Different results using same formula (table x script variable)

sunny_talwar — Fri, 06 Jan 2017 19:52:57 GMT

can you remove the = sign in front of your set variable in script and then try?

Re: Different results using same formula (table x script variable)

h_demarco — Fri, 06 Jan 2017 20:11:20 GMT

It showed up the text 'Sum(Duração_turno)' instead of number.

Re: Different results using same formula (table x script variable)

sunny_talwar — Fri, 06 Jan 2017 20:13:24 GMT

Now use your variable with dollar sign expansion

=$(VariableName)

Re: Different results using same formula (table x script variable)

h_demarco — Mon, 09 Jan 2017 10:52:00 GMT

It worked!

It is not clear the function of dollar sign, but I will search and try to understand it.

Thank you.