topic Define the Query. in QlikView https://community.qlik.com/t5/QlikView/Define-the-Query/m-p/140959#M753957 <HTML><HEAD></HEAD><BODY><P>Can someone explain the below query</P><P></P><P>( SUM({&lt;FLAG_QUESTION = <STRONG>{$1}&gt;}</STRONG>FLAG_PROMOTER) / SUM({&lt;FLAG_QUESTION = {$1}&gt;}FLAG_GROUP_ALL) * 100 )</P><P>-</P><P>( SUM({&lt;FLAG_QUESTION = <STRONG>{$1}&gt;}</STRONG>FLAG__DETRACTOR) / SUM({&lt;FLAG_QUESTION = {$1}&gt;}FLAG_GROUP_ALL) * 100)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT eromiyasimon 2020-11-25T16:16:04Z Define the Query. https://community.qlik.com/t5/QlikView/Define-the-Query/m-p/140959#M753957 <HTML><HEAD></HEAD><BODY><P>Can someone explain the below query</P><P></P><P>( SUM({&lt;FLAG_QUESTION = <STRONG>{$1}&gt;}</STRONG>FLAG_PROMOTER) / SUM({&lt;FLAG_QUESTION = {$1}&gt;}FLAG_GROUP_ALL) * 100 )</P><P>-</P><P>( SUM({&lt;FLAG_QUESTION = <STRONG>{$1}&gt;}</STRONG>FLAG__DETRACTOR) / SUM({&lt;FLAG_QUESTION = {$1}&gt;}FLAG_GROUP_ALL) * 100)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Define-the-Query/m-p/140959#M753957 eromiyasimon 2020-11-25T16:16:04Z Re: Define the Query. https://community.qlik.com/t5/QlikView/Define-the-Query/m-p/140960#M753958 <HTML><HEAD></HEAD><BODY><P>$1 refers to the first parameter of a parametrized variable which is usually called like:</P><P></P><P>$(var(1))</P><P></P><P>See also:</P><P></P><P><A class="jive-link-external-small" href="http://qlikviewmaven.blogspot.de/2011/04/variable-that-acts-like-user-defined.html" rel="nofollow" target="_blank"><SPAN lang="EN-GB" style="font-family: 'Arial',sans-serif;">Variable That Acts Like a User-Defined Function</SPAN></A><SPAN lang="EN-GB" style="font-family: 'Arial',sans-serif;">. </SPAN></P><P><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="5932" data-objecttype="102" href="https://community.qlik.com/docs/DOC-5932"><SPAN lang="EN-GB" style="font-family: 'Arial',sans-serif;">Dynamic Field Expressions with Variables</SPAN></A></P><P><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="9045" data-objecttype="102" href="https://community.qlik.com/docs/DOC-9045"><SPAN lang="EN-GB" style="font-family: 'Arial',sans-serif;">Variables with Parameters</SPAN></A></P><P></P><P>- Marcus</P></BODY></HTML> Mon, 08 Oct 2018 11:38:30 GMT https://community.qlik.com/t5/QlikView/Define-the-Query/m-p/140960#M753958 marcus_sommer 2018-10-08T11:38:30Z