topic Re: how to get value from expression to array in QlikView https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461439#M1304714 <HTML><HEAD></HEAD><BODY><P>Hi, thanks for your help!</P><P></P><P>How can i then get this values into array. Grom field i know it is like this:</P><P></P><P>set val=ActiveDocument.Fields("Sale").GetSelectedValues</P><P></P><P>I need something like this: set val= concat(Aggr(if(Sum (Sale)&gt; 10000,Sum (Sale)),Country), ',')</P></BODY></HTML> Tue, 29 Jan 2013 07:03:37 GMT 2013-01-29T07:03:37Z how to get value from expression to array https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461436#M1304706 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I have table with dimention - <STRONG>country</STRONG> and expression = <STRONG>if(Sum (Sale)&gt; 10000,Sum (Sale), )</STRONG></P><P></P><P>I know how to get value from field - </P><P></P><P>set sale=ActiveDocument.Fields("Sale").GetSelectedValues</P><P></P><P>Maybe you know how to get values from my expression <SPAN style="color: #333333;"><STRONG>if(Sum (Sale)&gt; 10000,Sum (Sale), )</STRONG></SPAN></P><P></P><P><SPAN style="color: #333333;">Please help, if you can</SPAN></P><P></P><P><SPAN style="color: #333333;"><BR /></SPAN></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461436#M1304706 2026-01-26T18:19:17Z Re: how to get value from expression to array https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461437#M1304710 <HTML><HEAD></HEAD><BODY><P>may be somebody know how to get value from dimention with expression?</P></BODY></HTML> Tue, 29 Jan 2013 06:08:57 GMT https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461437#M1304710 2013-01-29T06:08:57Z Re: how to get value from expression to array https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461438#M1304712 <HTML><HEAD></HEAD><BODY><P>&nbsp; hi ,</P><P></P><P>Use the below expression</P><P></P><P>=concat(Aggr(if(Sum (Sale)&gt; 10000,Sum (Sale)),Country), ',')</P><P></P><P>Pleas find the Attached app.. hope it helps you..</P></BODY></HTML> Tue, 29 Jan 2013 06:45:28 GMT https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461438#M1304712 2013-01-29T06:45:28Z Re: how to get value from expression to array https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461439#M1304714 <HTML><HEAD></HEAD><BODY><P>Hi, thanks for your help!</P><P></P><P>How can i then get this values into array. Grom field i know it is like this:</P><P></P><P>set val=ActiveDocument.Fields("Sale").GetSelectedValues</P><P></P><P>I need something like this: set val= concat(Aggr(if(Sum (Sale)&gt; 10000,Sum (Sale)),Country), ',')</P></BODY></HTML> Tue, 29 Jan 2013 07:03:37 GMT https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461439#M1304714 2013-01-29T07:03:37Z Re: how to get value from expression to array https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461440#M1304716 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>check the attached Application..</P><P></P><P>Hope it helps you..</P></BODY></HTML> Tue, 29 Jan 2013 08:49:05 GMT https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461440#M1304716 2013-01-29T08:49:05Z Re: how to get value from expression to array https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461441#M1304718 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I assume that you want to evaluate this expression in a VBscript module?</P><P></P><P>result = ActiveDocument.Evaluate("if(Sum (Sale)&gt; 10000,Sum (Sale))")</P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Tue, 29 Jan 2013 08:56:25 GMT https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461441#M1304718 jonathandienst 2013-01-29T08:56:25Z Re: how to get value from expression to array https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461442#M1304719 <HTML><HEAD></HEAD><BODY><P>unfortunatly i need get values real-time/ if i change <EM>filter - arrow must change to</EM></P></BODY></HTML> Tue, 29 Jan 2013 09:09:51 GMT https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461442#M1304719 2013-01-29T09:09:51Z Re: how to get value from expression to array https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461443#M1304720 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>thank you for help.</P><P></P><P>yes, i need expression in macro. But i need fill array with values of this expression.</P><P></P><P>i can fill array from field, using this: set val=ActiveDocument.Fields("Sale").GetSelectedValues</P><P></P><P>now i need fill my array with values from my expression - please look attachment in topic.</P><P></P><P>i already try to create table with dimention with this expression, and i can't fill aray with value of dimentons with expression</P></BODY></HTML> Tue, 29 Jan 2013 09:27:38 GMT https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461443#M1304720 2013-01-29T09:27:38Z Re: how to get value from expression to array https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461444#M1304721 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Create a variable in Front end and i think that will suffice..</P><P></P><P>Please check the attached app...</P><P></P><P>If this is not the required one.. please send us the Output format which is required</P></BODY></HTML> Wed, 30 Jan 2013 07:22:19 GMT https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461444#M1304721 2013-01-30T07:22:19Z Re: how to get value from expression to array https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461445#M1304722 <HTML><HEAD></HEAD><BODY><P>solve using by GetCell</P></BODY></HTML> Thu, 31 Jan 2013 14:04:12 GMT https://community.qlik.com/t5/QlikView/how-to-get-value-from-expression-to-array/m-p/461445#M1304722 2013-01-31T14:04:12Z