topic Re: combine column value within function on set analysis in QlikView

combine column value within function on set analysis

Sun, 29 Sep 2013 22:28:08 GMT

Hello,

I'm trying to combine some colume value inside a function inside set analysis expression.

In my expression Row_num is the expression value on my table that contaion some number.

This is the expression:

sum({$<[Part Name] = {"$(=FieldValue('Part Child Name5', Row_num))"} >} aggr([Part Total Balance], [Part Serial #]))

If I'm writing the expression without the Row_num column name, and put some number on one row, like this:

sum({$<[Part Name] = {"$(=FieldValue('Part Child Name5', 2))"} >} aggr([Part Total Balance], [Part Serial #]))

or some other number from the Row_num column data, the expression is working...

I need to put the Row_num so that the expression will be dynamic.

Many Thanks for your support,

Itsik

nizamsha — Mon, 30 Sep 2013 11:55:15 GMT

aggr(sum({$<[Part Name] = {"$(=FieldValue('Part Child Name5', 2))"} >} ,[Part Total Balance], [Part Serial #])

Mon, 30 Sep 2013 13:08:32 GMT

Hi Nizam and thanks for yours reply,

I posted some other question that coverd all my problem.

Please see it and answer we if you can.

Thank you!

Itsik