8 Replies Latest reply: May 22, 2012 3:33 AM by Abdur Razak Amod

# Positive value works, but not negative values does not work in set analysis

Hi,

I have the following expression, it gives me the description of the Instrument with the highest Marketvalue,which works fine:

=

Minstring({< MarketValue = {\$(=Num(Max({<[Sector] = {'Equity'}>} MarketValue)))} >} [InstrumentDescription])

However, when I try this to get the Instrument with the lowest MarketValue I get nothing returned, Iuse the below expression.

=

Minstring({< MarketValue = {\$(=Num(Min({<[Sector] = {'Equity'}>} MarketValue)))} >} [InstrumentDescription])

Any help is appreciated....

Regards

Razak

• ###### Positive value works, but not negative values does not work in set analysis

Did you mean to switch [Sector] with [AssetClass]?  If so, what are the dimensions?

• ###### Positive value works, but not negative values does not work in set analysis

Hi,

I am using this expression in a text box object, and both are suppose to be Sector, I have edited the above post.

Thanks

• ###### Positive value works, but not negative values does not work in set analysis

Have you tried putting

=Num(Min({<[Sector] = {'Equity'}>} MarketValue))

in a text box and then selecting this value in field MarketValue and check the possible values of InstrumentDescription?

• ###### Positive value works, but not negative values does not work in set analysis

Hi,

I did that

=Num(Min({<[Sector] = {'Equity'}>} MarketValue)),

I get a Value for this and i checked whether there exists an InstrumentDescription for this value,

The expression:

=

Minstring({< MarketValue = {\$(=Num(Min({<[Sector] = {'Equity'}>} MarketValue)))} >} [InstrumentDescription])

it does return a value when the minimum is positive however when the value is negative I get nothing.

Sorry forgot to add that in.

Kind Regards

Razak

• ###### Positive value works, but not negative values does not work in set analysis

I assume that your issue is a formatting issue.

What is your standard numerical format? Do you have decimals in your numbers?

Have you tried enclosing the dollar sign expansion into single quotes?

Could you post a small sample QV file here to the forum?

• ###### Re: Positive value works, but not negative values does not work in set analysis

Hi, please see attachment, the red textbox is the problem.

Thanks for the help.

Regards

Razak

• ###### Re: Positive value works, but not negative values does not work in set analysis

Hi,

Use this expression

=Minstring({< Value ={'\$(=Num(Min({<[AssetClass] = {'Equity'}>} Value)))'} >} Distinct [Security])

Regards

Perumal

• ###### Re: Positive value works, but not negative values does not work in set analysis

Thank You!!!