Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Show max () Dimension In Stright Table

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

Capture.PNG.png

TABLE 2

Capture2.PNG.png

Thanks,

GM

Tags (1)
1 Solution

Accepted Solutions

Re: Show max () Dimension In Stright Table

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


talk is cheap, supply exceeds demand
5 Replies

Re: Show max () Dimension In Stright Table

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


talk is cheap, supply exceeds demand
Not applicable

Re: Show max () Dimension In Stright Table

Ok,

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

Re: Show max () Dimension In Stright Table

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


talk is cheap, supply exceeds demand
MVP
MVP

Re: Show max () Dimension In Stright Table

see attachment

Not applicable

Re: Show max () Dimension In Stright Table

Thank's very helpfull!!!

Community Browser