Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
h_demarco
Contributor III
Contributor III

Different results using same formula (table x script variable)

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:

QVTable.JPG

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

QVTempoCal1.JPG

[Tempo Calendario2] is tempo_calendario  (variable)

QVTempoCal2.JPG

in script I have

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

QVScript.JPG

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

1 Solution

Accepted Solutions
sunny_talwar

Now use your variable with dollar sign expansion

=$(VariableName)

View solution in original post

4 Replies
sunny_talwar

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

h_demarco
Contributor III
Contributor III
Author

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

sunny_talwar

Now use your variable with dollar sign expansion

=$(VariableName)

View solution in original post

h_demarco
Contributor III
Contributor III
Author

It worked!

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

Thank you.