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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

why we use $1? when i am using this in variable overview window inside definition tab it is showing error.

when i am performing Sum([# Departures Performed]) /$1 this it showing error in $1 why it is showing m not getting ?

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Context is all. Where is it?

You can use an identifier like that to mean:

  • the first parameter in a User-defined-function using variables
  • selection 1 from the backstack (e.e. the previous selection) in set analysis
  • a variable or field name that has been explicitly defined before

You seem to be using a fourth possibility that QlikView doesn't understand.

Best,

Peter

[Edit] Translated some stubby-finger gibberish into English. Hope I succeeded...

Anonymous
Not applicable
Author

Hi Anshita,

when you write $1 on vars, you are writting parameters.

Example:

     Var1-> Sum(Amount)/$1

     $1 depends of the value that you pass when calling Var1

     Calling Var1-> $(Var1(3))

     $1 take 3 value.

Regards!!