topic help needed on variable in QlikView

help needed on variable

Fri, 11 Nov 2011 12:50:17 GMT

can any one please tell me that how can I store expression result in a variable

thanks in advance

ab prince

help needed on variable

SunilChauhan — Fri, 11 Nov 2011 13:00:33 GMT

you can write directly expression into variable

ex:

var =sum(amount)

help needed on variable

Fri, 11 Nov 2011 13:03:34 GMT

thanks sunil for prompt reply,

but I want to store a straight table column expression result in variable

help needed on variable

swuehl — Fri, 11 Nov 2011 13:10:21 GMT

I don't think you can pass a straight table columns expression result directly into a variable.

But you can try rebuilding the table result within an expression, using advanced aggregation. You would need to give us some more details, if you like some help on that.

If you want to reuse the columns result in another column of the same table, try using the expression label referencing or column() function.

Regards,

Stefan

help needed on variable

Fri, 11 Nov 2011 13:16:20 GMT

Thanks Stefan

Please give me some time I am trying to provide you more details.

but can you tell me which advance aggregation I will use to preserve to result in variable

help needed on variable

swuehl — Fri, 11 Nov 2011 13:43:45 GMT

I am talking about the aggr() function. This function could be used to e.g. retrieve a total value for an expression that needs to be grouped by dimensions, for example if you want to get the max value of sum of Days Worked per Week per Employee, like max(sum( hours), Employee, Week)

This would be equivalent to build a table with Employee and Week as dimensions, sum(hours) as expression and looking for the max value (e.g. by total mode max of rows in a straight table).

This is only a simple and short example.

There are some requirements that you may handle with the use of the aggr() function, and others you may not.

help needed on variable

Fri, 11 Nov 2011 18:16:41 GMT

Thanks Stefan