Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to change the variables order ?

Hi !

I would like to know how (id possible) I can change the order of my variables.

I have the following variables :

varA --> 1
varB --> 2
varC --> $(varA) + $var(B)
.
. (many variables here, using "varC")
.
varZ --> $(varC) + 1

I realize that "varC" is not "$(varA) + $var(B)", but "$(varA) + $var(B) + $varBprime". So, I want to add a "varBprime" variable before "varC".

But I can't !

My new variable is always at the end of the list...

The only thing I can do is delete and create all my variables !!!

2 Replies
Miguel_Angel_Baeyens

Hello,

Depending on how are you going to use those variables, you can SET them in load time in the script, and change them later on in expressions, for example.

Not applicable
Author

Unfortunatly, my variables have a content that cannot be calculated at the loading.

For exemple, I have this variable :

=sum({$<[Year]={$(#=Only(Year)-1)}>} [Incoming])


I can only set this variable in the document properties, because if set in the loading part, the expression becomes

<pre>=sum({$<[Year]={$(0)}>} [Incoming])