topic Re: Set Analysis with Variable in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-Variable/m-p/454628#M489142 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hello,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">try this :</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">=(Avg({$&lt;L_Z1V2={"&gt;$(vUG_KH)&lt;$(vOG_KH)"}&gt;} L_Z1V2))</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Create two variables vUG_KH and vOG_KH with values 0,120&nbsp; and 0,249</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Cheers!!</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Jagan</SPAN></P></BODY></HTML> Wed, 21 Nov 2012 10:32:44 GMT jagannalla 2012-11-21T10:32:44Z Set Analysis with Variable https://community.qlik.com/t5/QlikView/Set-Analysis-with-Variable/m-p/454627#M489140 <HTML><HEAD></HEAD><BODY><P>Hey!</P><P></P><P>I have this expression: </P><P></P><P>Avg ({&lt;L_Z1V2={'&gt;0,120'}&gt;*&lt;L_Z1V2={'&lt;0,249'}&gt;}L_Z1V2)</P><P></P><P>I just want to change 0,120 for a variable called UG_KH and 0,249 for OG_KH. It should be easy but I don't find the right syntaxe. </P><P></P><P>Thank you very much!!!!</P><P></P><P></P><P>Eduardo </P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P></BODY></HTML> Wed, 21 Nov 2012 10:23:30 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Variable/m-p/454627#M489140 2012-11-21T10:23:30Z Re: Set Analysis with Variable https://community.qlik.com/t5/QlikView/Set-Analysis-with-Variable/m-p/454628#M489142 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hello,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">try this :</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">=(Avg({$&lt;L_Z1V2={"&gt;$(vUG_KH)&lt;$(vOG_KH)"}&gt;} L_Z1V2))</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Create two variables vUG_KH and vOG_KH with values 0,120&nbsp; and 0,249</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Cheers!!</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Jagan</SPAN></P></BODY></HTML> Wed, 21 Nov 2012 10:32:44 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Variable/m-p/454628#M489142 jagannalla 2012-11-21T10:32:44Z Re: Set Analysis with Variable https://community.qlik.com/t5/QlikView/Set-Analysis-with-Variable/m-p/454629#M489144 <HTML><HEAD></HEAD><BODY><P>Thank you very much! This "v" solves the problem with "." und ","!!!</P><P></P><P>Eduardo</P></BODY></HTML> Wed, 21 Nov 2012 11:25:46 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Variable/m-p/454629#M489144 2012-11-21T11:25:46Z