Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

how to get value from expression to array

Hi!

I have table with dimention - country and expression = if(Sum (Sale)> 10000,Sum (Sale), )

I know how to get value from field -

set sale=ActiveDocument.Fields("Sale").GetSelectedValues

Maybe you know how to get values from my expression if(Sum (Sale)> 10000,Sum (Sale), )

Please help, if you can


Tags (1)
9 Replies
Not applicable

Re: how to get value from expression to array

may be somebody know how to get value from dimention with expression?

Not applicable

Re: how to get value from expression to array

  hi ,

Use the below expression

=concat(Aggr(if(Sum (Sale)> 10000,Sum (Sale)),Country), ',')

Pleas find the Attached app.. hope it helps you..

Not applicable

Re: how to get value from expression to array

Hi, thanks for your help!

How can i then get this values into array. Grom field i know it is like this:

set val=ActiveDocument.Fields("Sale").GetSelectedValues

I need something like this: set val= concat(Aggr(if(Sum (Sale)> 10000,Sum (Sale)),Country), ',')

Not applicable

Re: how to get value from expression to array

Hi

check the attached Application..

Hope it helps you..

MVP
MVP

Re: how to get value from expression to array

Hi

I assume that you want to evaluate this expression in a VBscript module?

result = ActiveDocument.Evaluate("if(Sum (Sale)> 10000,Sum (Sale))")

Hope that helps

Jonathan

Not applicable

Re: how to get value from expression to array

unfortunatly i need get values real-time/ if i change filter - arrow must change to

Not applicable

Re: how to get value from expression to array

Hi!

thank you for help.

yes, i need expression in macro. But i need fill array with values of this expression.

i can fill array from field, using this: set val=ActiveDocument.Fields("Sale").GetSelectedValues

now i need fill my array with values from my expression - please look attachment in topic.

i already try to create table with dimention with this expression, and i can't fill aray with value of dimentons with expression

Not applicable

Re: how to get value from expression to array

Hi,

Create a variable in Front end and i think that will suffice..

Please check the attached app...

If this is not the required one.. please send us the Output format which is required

Not applicable

Re: how to get value from expression to array

solve using by GetCell

Community Browser