Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Want to know value in field when another is at maximum for current selections

Hi community,

I have a straight table that has dimension 1 and expresion 1.

The expression I want is the value in one field when another is at is max for the current selections.  Anyway I can do that?  The dimension is neither of the fields in the expression so something like:

if(date#(DATES)=max(total DATES),Status/100) doesn't work because Dates isn't my dimension

1 Reply
MVP
MVP

Re: Want to know value in field when another is at maximum for current selections

Look into FirstSortedValue, which could solve your request, like

=FirstSortedValue(Status, -DATES)


Community Browser