Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dreamer78692
Contributor

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

1 Solution

Accepted Solutions
perumal_41
Valued Contributor II

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

8 Replies
jason_michaelid
Honored Contributor II

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?

dreamer78692
Contributor

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

MVP
MVP

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

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?

dreamer78692
Contributor

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

MVP
MVP

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?

dreamer78692
Contributor

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

perumal_41
Valued Contributor II

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

dreamer78692
Contributor

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

Thank You!!!

Community Browser