topic How to use a variable to create a dynamic expression in QlikView https://community.qlik.com/t5/QlikView/How-to-use-a-variable-to-create-a-dynamic-expression/m-p/146710#M25226 <HTML><HEAD></HEAD><BODY><P>Thank you!!! That what my problem was :).</P></BODY></HTML> Sat, 13 Jun 2009 03:53:46 GMT 2009-06-13T03:53:46Z How to use a variable to create a dynamic expression https://community.qlik.com/t5/QlikView/How-to-use-a-variable-to-create-a-dynamic-expression/m-p/146708#M25224 <HTML><HEAD></HEAD><BODY><P>I am new to QlikView so any help on this is greatly appreciated.</P><P>With the current version of our corporate dashboard, we have a simple bar chart with below expression define on the expression tab of the chart.</P><P>COUNT(ENROLLED_STUDENT_KEY) / COUNT(DISTINCT IF(ENROLLED_FLAG = 1, PERSON_ID))</P><P>The new requirement from our business users calls for dynamic calculation of the denominator as shown below.</P><P></P><P>COUNT(ENROLLED_STUDENT_KEY) / COUNT(DISTINCT IF( Dynamic Expression Here , PERSON_ID))</P><P>I attempted to use a variable as shown below. My idea was to have the value of the variable set to whatever the filter selected by the user. I tested this idea by defining the value the variable to 'ENROLLED_FLAG = 1' (without the quotes) but the chart would simply not render.</P><P>COUNT(ENROLLED_STUDENT_KEY)/COUNT(DISTINCT IF(=<B><I>$(StudentPopulationFlag)</I></B>, PERSON_ID))</P><P></P><P></P><BR /><BR /></BODY></HTML> Sat, 13 Jun 2009 03:34:48 GMT https://community.qlik.com/t5/QlikView/How-to-use-a-variable-to-create-a-dynamic-expression/m-p/146708#M25224 2009-06-13T03:34:48Z How to use a variable to create a dynamic expression https://community.qlik.com/t5/QlikView/How-to-use-a-variable-to-create-a-dynamic-expression/m-p/146709#M25225 <HTML><HEAD></HEAD><BODY><P>I don't think you want the equal sign before the dollar sign expansion. Have you tried it without?</P><P>Other than that, the expression looks sound.</P></BODY></HTML> Sat, 13 Jun 2009 03:41:06 GMT https://community.qlik.com/t5/QlikView/How-to-use-a-variable-to-create-a-dynamic-expression/m-p/146709#M25225 2009-06-13T03:41:06Z How to use a variable to create a dynamic expression https://community.qlik.com/t5/QlikView/How-to-use-a-variable-to-create-a-dynamic-expression/m-p/146710#M25226 <HTML><HEAD></HEAD><BODY><P>Thank you!!! That what my problem was :).</P></BODY></HTML> Sat, 13 Jun 2009 03:53:46 GMT https://community.qlik.com/t5/QlikView/How-to-use-a-variable-to-create-a-dynamic-expression/m-p/146710#M25226 2009-06-13T03:53:46Z