Ranking in a table

[asa_runstrom]

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?

[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 · Accepted solution]

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