Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
asa_runstrom
Contributor III
Contributor III

Ranking in a table

 

Hi

I have built a table that look like this.

 

 

My client want me to only show the three question with lowest %. Is that possible?

 

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

2 Replies
sunny_talwar

What is your dimension and expressions here? May be use conditional show here:

1st expression conditional Show

RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) <= Exp1

2nd expression conditional Show

RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) <= Exp2

3rd expression conditional Show

RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) <= Exp3

4th expression conditional Show

RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) <= Exp4

5th expression conditional Show

RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) <= Exp5

Replace Exp1, Exp2, .... , Exp5 with the original expressions

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You might find some inspiration in this example:

Qlikview Cookbook: Outliers http://qlikviewcookbook.com/recipes/download-info/outliers/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com