Hi

[#1]

Hi All,

I am new to Qlikview, could you please help me on this request?

Using set analysis how we can dynamically fetch the maximum value.

I used the following expression but which is not produce anything.

sum({1<[Shipping Fee]= {"$=(Max([Shipping Fee])"}>}[Order-Total])

[#2]

Please refer the sample data

[#3]

If I give this expression

sum({<[Shipping Fee]= {200}>}[Order-Total]) working fine.

Note: Shipping Fee = 200 is maxmum value in my data

On Mon, Dec 22, 2014 at 8:50 PM, Anand Chouhan <qcwebmaster@qlikview.com>

[#4]

If I give this expression

sum({<[Shipping Fee]= {200}>}[Order-Total]) working fine.

Note: Shipping Fee = 200 is maxmum value in my data

[its_anandrjs]

Try this expression

=sum({<[Shipping Fee] = {'$(=Max([Shipping Fee]))'}>}[Order-Total])

It is worked at my end.

Regards

Anand

[narband2778]

hi,

PFA QV Document.

KR,

Naresh

[#7]

Hi Satheesh,

Please try this below expression. I hope its help for you.

=Sum({<Shipping={$(=Max(Shipping))}>}[Order-Total])

Regards,

@Sub2u

[#8]

This expression is working fine- Thanks

[Anonymous]

So the issue is resolved now!!!