Discussion Board for collaboration related to Creating Analytics for QlikView.
Hi. I'm searching for the way to show dimention value in text box.I've got currency rates by banks in single table. And my problem is to show the bank with the best rate.My expression looks like: max(aggr(sum(Rate),Bank)).
Go to Solution.
HI See Attached example,
I loaded a few Lines
LOAD * INLINE [ Bank, Rate A, '0,7' B, '0,8' C, '0,5' D, '1,2' E, '1,1'];
I want Bank D to show as the bank with the highest rate
First I determen the row containing the highest rate:
fieldindex( 'Rate', max(Rate) ))--> row number 4
Finnaly I retrieve the value of Bank in the 4th row:
Fieldvalue('Bank',fieldindex( 'Rate', max(Rate) ))
And what does that expression bring back?
Best Banks Rate I think.
Can you post your data, Current result and Expected result?
Please put an example to understando and can help you
I hope it helps.