Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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