topic Advanced Topics - Parameterized Variables book example question in QlikView

Advanced Topics - Parameterized Variables book example question

jblomqvist — Fri, 28 Aug 2015 09:42:53 GMT

Hi,

In the Advanced Topics book on page 84 for Advanced Set Analysis, it uses the example of

Sum($1) / Sum(TOTAL $1)

What does the 1 represent? Is it a variable? It is not clear what is meant by this in the book.

Thanks

Gysbert_Wassenaar — Fri, 28 Aug 2015 10:38:56 GMT

$1 means the first parameter passed to the variable. In this case it's also the only parameter and it would be a field name. For example

eSales: Sum($1) / Sum(TOTAL $1)

Expression: =if( vCurrency = 'USD', $(eSales(Sales_USD)), $(eSales(Sales_EUR)))