Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
eromiyasimon
Contributor II

Define the Query.

Can someone explain the below query

( SUM({<FLAG_QUESTION = {$1}>}FLAG_PROMOTER) / SUM({<FLAG_QUESTION = {$1}>}FLAG_GROUP_ALL) * 100 )

-

( SUM({<FLAG_QUESTION = {$1}>}FLAG__DETRACTOR) / SUM({<FLAG_QUESTION = {$1}>}FLAG_GROUP_ALL) * 100)

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: Define the Query.

$1 refers to the first parameter of a parametrized variable which is usually called like:

$(var(1))

See also:

Variable That Acts Like a User-Defined Function.

Dynamic Field Expressions with Variables

Variables with Parameters

- Marcus