Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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_Michaelides
Luminary Alumni
Luminary Alumni

try:

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

Hope this helps,

Jason

Anonymous
Not applicable
Author

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