topic Re: Conditional Expression in QlikView

Conditional Expression

lylererger — Mon, 14 Apr 2014 12:25:52 GMT

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)).

Thnx.

Re: Conditional Expression

ThornOfCrowns — Mon, 14 Apr 2014 12:30:57 GMT

And what does that expression bring back?

Re: Conditional Expression

lylererger — Mon, 14 Apr 2014 12:33:44 GMT

Best Banks Rate I think.

Re: Conditional Expression

anbu1984 — Mon, 14 Apr 2014 12:37:52 GMT

Can you post your data, Current result and Expected result?

Re: Conditional Expression

fkeuroglian — Mon, 14 Apr 2014 12:40:39 GMT

Please put an example to understando and can help you

Re: Conditional Expression

lylererger — Mon, 14 Apr 2014 12:46:41 GMT

I hope it helps.

Re: Conditional Expression

bertdijks — Mon, 14 Apr 2014 12:53:58 GMT

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) ))

Kind regards,

Bert