différence between a variable with a dollar symbole and variable without dollar symbole after the Let keyword
Hi everyon, i am new to qlik. i would like to know what do these codes mean and what is difference between these two TempVarName.
Thank you in advance for your explanation.
FOR i=0 to '$(RowCount)' LET TempVarName = Peek('ExpressionID', $(i), 'Expression'); LET $(TempVarName) = Peek('ExpressionValue', $(i), 'Expression'); NEXT
This script looped through a loaded table "Expression" - probably from an external source like an Excel or a data-base - which contained at least two fields with a name information and an expression information.
The name information is then fetched by Let TempVarName ... and assigned to this variable and within the next step this information is used per Let $(TempVarName) ... to create a new variable which get the expression-part as content.
The aim of it is therefore to create variables within the script - automated and externally controlled. The idea behind it has some charm but it requires a quite systematically approach within the data-architecture and will create some overhead. So it won't be suitable for each scenario.
This script looped through a loaded table "Expression" - probably from an external source like an Excel or a data-base - which contained at least two fields with a name information and an expression information.
The name information is then fetched by Let TempVarName ... and assigned to this variable and within the next step this information is used per Let $(TempVarName) ... to create a new variable which get the expression-part as content.
The aim of it is therefore to create variables within the script - automated and externally controlled. The idea behind it has some charm but it requires a quite systematically approach within the data-architecture and will create some overhead. So it won't be suitable for each scenario.
