Solved: Re: Max() function problem - Qlik Community

srikantj · ‎2017-03-20

Hi Qlikss

I have a field names sales

sales

2

5

354

678

when i use max(sales) in text object it is giving 678... which is correct

but when i use same function max(sales) in straight table. its giving no value

and i have 10 other fields in straight table.

Qlikss suggest

Anil_Babu_Samineni · ‎2017-03-20

May be this in straight

Sum({<sales = {'$(=Max(sales))'}>}sales)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2017-03-20

May be this in straight

Sum({<sales = {'$(=Max(sales))'}>}sales)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-03-20

Whats the expected output?

vardhancse · ‎2017-03-20

out of some 10 fields, only for one table we can set to show max.