Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

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

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