combine column value within function on set analysis

[#1]

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]

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

[#3]

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.

http://community.qlik.com/thread/94430

Thank you!

Itsik