topic Re: Find the Max value with field name in QlikView

Find the Max value with field name

eromiyasimon — Wed, 25 Nov 2020 16:16:04 GMT

i have some types of subjects for four different students and i want calculate the max marks along with subject name in a chart

here i attached the sample data,

in the given data i want to display the maximum amount of region number along with loan type.

thanks in advance

Re: Find the Max value with field name

sunny_talwar — Mon, 17 Oct 2016 18:20:49 GMT

Do you have Region and Loan Type as your dimension? May be you need this:

Max(Total <Region> Aggr(Sum(Amount), Region, [Loan Type]))

Re: Find the Max value with field name

eromiyasimon — Mon, 17 Oct 2016 18:58:52 GMT

HI sunny,

thanks for your reply,

im expecting result like this.

thanks in advance

Re: Find the Max value with field name

sunny_talwar — Mon, 17 Oct 2016 19:28:37 GMT

Does this look right?

Dimension:

Region

Expression:

=Dual(FirstSortedValue([Loan type], -Aggr(Sum(Amount), Region, [Loan type])) & ' - ' & Max(Aggr(Sum(Amount), Region, [Loan type])), Max(Aggr(Sum(Amount), Region, [Loan type])))

Re: Find the Max value with field name

eromiyasimon — Mon, 17 Oct 2016 19:44:17 GMT

sunny still im not getting what i expected.

attached the result what im getting now using your expression and Dimension

kindly attach the QVW if you can

Re: Find the Max value with field name

sunny_talwar — Mon, 17 Oct 2016 20:00:03 GMT

If you open this link Re: Find the Max value with field name, you will see the qvw attached.

Are you not happy with the numbers you are seeing 24, 78, 98, 76 or are you not happy because you don't see the Loan Type? For seeing the loan type, change the format to 'Expression Default' on the number tab of chart properties

Re: Find the Max value with field name

eromiyasimon — Mon, 17 Oct 2016 20:11:19 GMT

sunny you are soo helpful,

i wish one day i were like you.

thanks a lot.

May god bless you

Re: Find the Max value with field name

sunny_talwar — Mon, 17 Oct 2016 20:17:46 GMT

I am glad I was able to help brother .

Best,

Sunny