topic Re: Show max () Dimension In Stright Table in QlikView

Show max () Dimension In Stright Table

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

it's possible to reduce Table 1 to Table 2?

Chatacter is a dimension, and I want to show only the max Character linked to the result of max()

TABLE1

TABLE 2

Thanks,

Gysbert_Wassenaar — Mon, 30 Jun 2014 10:50:36 GMT

Try using Dimension Limits to limit the results to the Largest 1 values.

Mon, 30 Jun 2014 11:12:18 GMT

Ok,

it's great but it's possible to make an Expression for the same results?

Gysbert_Wassenaar — Mon, 30 Jun 2014 11:24:19 GMT

Yes, you can use the rank function in an if statement. if(rank(something)=1,something)

maxgro — Mon, 30 Jun 2014 11:33:09 GMT

see attachment

Mon, 30 Jun 2014 15:55:05 GMT

Thank's very helpfull!!!