Book - Qlikview 11 for developers

Wed, 02 Apr 2014 00:49:01 GMT

On page 340, the book straight table is like -

But, my table is like -

Why is there a difference ? I followed the steps correctly.

Here are the steps -

Dollar Sign Expansion with parameters

It is also possible to create variables with parameters and then call them via a DSE

specifying the parameter's value, thus allowing extended flexibility and reusability

of variables.

The way we create a variable with parameters is as follows:

1. Open the Variable Overview… window (Ctrl + Alt + V) and create a new

variable. Name it eDeparturesPerformed_VarUnit .

2. The variable definition will be:

Sum([# Departures Performed]) / $1

3. In the Comment field, enter Variable to calculate the number of

departures performed with variable divisor .

4. Close the Variable Overview… window by clicking on OK.

more stuff here.................................

To use the above variable in an expression, start by creating a new chart in the

form of a straight table with Carrier Group as the dimension and the following

three expressions:

1. The first expression, labeled # of Flights , will be:

$(eDeparturesPerformed_VarUnit(1))

2. The second expression, labeled # of Flights (thousands) , will be:

$(eDeparturesPerformed_VarUnit(1000))

3. The third expression, labeled # of Flights (millions) , will be:

$(eDeparturesPerformed_VarUnit(1000000))

topic Book - Qlikview 11 for developers in QlikView