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

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

Anonymous — Mon, 21 May 2012 12:29:26 GMT

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

Jason_Michaelides — Mon, 21 May 2012 12:37:01 GMT

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

Anonymous — Mon, 21 May 2012 12:39:24 GMT

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

swuehl — Mon, 21 May 2012 13:02:40 GMT

Could you tell us a bit more about your data model?

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

Anonymous — Mon, 21 May 2012 13:27:49 GMT

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

swuehl — Mon, 21 May 2012 14:19:44 GMT

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

Anonymous — Tue, 22 May 2012 07:09:38 GMT

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

perumal_41 — Tue, 22 May 2012 07:26:32 GMT

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

Anonymous — Tue, 22 May 2012 07:33:41 GMT

Thank You!!!