topic Re: EXPRESSION IN FIELD in QlikView https://community.qlik.com/t5/QlikView/EXPRESSION-IN-FIELD/m-p/1237533#M393426 <HTML><HEAD></HEAD><BODY><P>May be like this,</P></BODY></HTML> Tue, 07 Mar 2017 07:48:05 GMT muthukumar77 2017-03-07T07:48:05Z EXPRESSION IN FIELD https://community.qlik.com/t5/QlikView/EXPRESSION-IN-FIELD/m-p/1237530#M393423 <HTML><HEAD></HEAD><BODY><P> hi</P><P>i have a field that contain an expression</P><P>i added in the end a sample of my table</P><P></P><P>in my UI i have a screen that i must choose one metric</P><P>and in this screen i want to create a chart that the expression of the chart will be the exp field</P><P></P><P></P><P>how can i do it?</P><P>is there a way of doing that without a variable?</P><P></P><P>adi</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>metric</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>exp</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;">sum(amount)</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">avg(amount)</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">min(amount)</TD></TR></TBODY></TABLE><P>x</P><P></P><P></P><P>cccccccc</P></BODY></HTML> Mon, 06 Mar 2017 16:02:05 GMT https://community.qlik.com/t5/QlikView/EXPRESSION-IN-FIELD/m-p/1237530#M393423 adiarnon 2017-03-06T16:02:05Z Re: EXPRESSION IN FIELD https://community.qlik.com/t5/QlikView/EXPRESSION-IN-FIELD/m-p/1237531#M393424 <HTML><HEAD></HEAD><BODY><P>how many metric values you have? change accordingly as you required.</P><P></P><P>Take Straight Table</P><P><STRONG>ValueLoop(1,3)</STRONG> -- Give name as <STRONG>metric</STRONG></P><P></P><P>Expression may be using this</P><P><STRONG>If(ValueLoop(1,3)=1, Sum(amount), If(ValueLoop(1,3)=2, Avg(amount), If(ValueLoop(1,3)=3, Min(amount))))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Or</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Pick(Match(ValueLoop(1,3),1,2,3), Sum(amount), avg(amount), min(amount))<BR /></STRONG></P></BODY></HTML> Mon, 06 Mar 2017 16:06:44 GMT https://community.qlik.com/t5/QlikView/EXPRESSION-IN-FIELD/m-p/1237531#M393424 Anil_Babu_Samineni 2017-03-06T16:06:44Z Re: EXPRESSION IN FIELD https://community.qlik.com/t5/QlikView/EXPRESSION-IN-FIELD/m-p/1237532#M393425 <HTML><HEAD></HEAD><BODY><P>hi. but for this solution i dont need the expression in the field...</P><P>the idea is that the expression is dymanic and extract from a table.</P><P></P><P>adi</P></BODY></HTML> Tue, 07 Mar 2017 07:06:14 GMT https://community.qlik.com/t5/QlikView/EXPRESSION-IN-FIELD/m-p/1237532#M393425 adiarnon 2017-03-07T07:06:14Z Re: EXPRESSION IN FIELD https://community.qlik.com/t5/QlikView/EXPRESSION-IN-FIELD/m-p/1237533#M393426 <HTML><HEAD></HEAD><BODY><P>May be like this,</P></BODY></HTML> Tue, 07 Mar 2017 07:48:05 GMT https://community.qlik.com/t5/QlikView/EXPRESSION-IN-FIELD/m-p/1237533#M393426 muthukumar77 2017-03-07T07:48:05Z