Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

Advanced Topics - Parameterized Variables book example question

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

1 Reply
Gysbert_Wassenaar

$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)))


talk is cheap, supply exceeds demand