Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dreamer78692
Contributor

Get specific value of field

Hi,

I am trying to get the description of a tjhe value associated with it:

for the value I have this expression,

Sum(Aggr(If([Sector] = 'Other Equity', MAX(MarketValue)),Sector)

This gives me the value I need, Now I need the InstrumentDescription associated with this value,

I tried using the ffg:

=if(MarketValue=Sum(Aggr(If([Sector] = 'Other Equity', MAX(MarketValue)),Sector)),InstrumentDescription)

But, unfortunately I do not get anything.

Does anybody know a way of doing this...

Kind Regards,

Razak

2 Replies
jason_michaelid
Honored Contributor II

Get specific value of field

try:

Only({<MarketValue={"=Sum(Aggr(If([Sector] = 'Other Equity', MAX(MarketValue)),Sector)"}>} InstrumentDescription)

Hope this helps,

Jason

dreamer78692
Contributor

Get specific value of field

Hi,

I got this to work:

=

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

This gives me the Highest value, but I also want the lowest value, But when I do this

=

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

i.e. change Max to Min to get the least value I get nothing just a dash(-).

Can you please help me with this...

Regards

Razak

Community Browser