topic Help on parameter passing in QlikView https://community.qlik.com/t5/QlikView/Help-on-parameter-passing/m-p/742047#M1031004 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am looking to add a condition to the below expression so that it pass the parameter of a region field. (the sum of sales for the selected region should be added to the below expression)</P><P></P><P>=sum({&lt;Region={'$(Region)'&gt;}Sum([Time to complete])/Sum(Total [Time to complete])*Sum(Resource))</P><P></P><P>I tried the above expression. However, not getting the desired output.</P></BODY></HTML> Tue, 17 Feb 2015 23:37:38 GMT 2015-02-17T23:37:38Z Help on parameter passing https://community.qlik.com/t5/QlikView/Help-on-parameter-passing/m-p/742047#M1031004 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am looking to add a condition to the below expression so that it pass the parameter of a region field. (the sum of sales for the selected region should be added to the below expression)</P><P></P><P>=sum({&lt;Region={'$(Region)'&gt;}Sum([Time to complete])/Sum(Total [Time to complete])*Sum(Resource))</P><P></P><P>I tried the above expression. However, not getting the desired output.</P></BODY></HTML> Tue, 17 Feb 2015 23:37:38 GMT https://community.qlik.com/t5/QlikView/Help-on-parameter-passing/m-p/742047#M1031004 2015-02-17T23:37:38Z Re: Help on parameter passing https://community.qlik.com/t5/QlikView/Help-on-parameter-passing/m-p/742048#M1031005 <HTML><HEAD></HEAD><BODY><P>The syntax $(Region) would refer to a variable, not a field value. To include the selected Region, remove the entire Set {} expression. Including selected data is the default.</P><P></P><P>-Rob </P></BODY></HTML> Wed, 18 Feb 2015 02:54:26 GMT https://community.qlik.com/t5/QlikView/Help-on-parameter-passing/m-p/742048#M1031005 rwunderlich 2015-02-18T02:54:26Z