Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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
MVP & Luminary
MVP & Luminary

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

View solution in original post

5 Replies
MVP & Luminary
MVP & Luminary

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?

MVP & Luminary
MVP & Luminary

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

View solution in original post

MVP
MVP

Re: Show max () Dimension In Stright Table

see attachment

Not applicable

Re: Show max () Dimension In Stright Table

Thank's very helpfull!!!