topic Re: Help with Ranking Multiple Expressions in QlikView

Help with Ranking Multiple Expressions

Fri, 19 Apr 2013 14:16:12 GMT

Hi,

I need help with ranking multiple expressions in a pivot
table with on dimension. Currently my
table looks like below:

What I need is the focus area for each row where development
= “Yes” to give me the header for the lowest score in Column range 2 to 6. Is
this possible?

Regards

Re: Help with Ranking Multiple Expressions

Fri, 19 Apr 2013 14:41:31 GMT

I am trying to use some thing like:

if(Column(7)='Yes', If

(Column(2)<Column(3) and Column(2)< Column(4) and Column(2)< Column(5),vRank1,1))

vRank1 = 'Add Product'

However it falls appart because of the '-'. Any suggestions please?

Regards R

Re: Help with Ranking Multiple Expressions

Gysbert_Wassenaar — Sat, 20 Apr 2013 10:23:02 GMT

Try using the rangemin function:

If( Column(7)='Yes',

if( rangemin(Column(2), Column(3),..etc ) = Column2, '% tNPS (overall)',

if( rangemin(Column(2), Column(3),..etc ) = Column3, 'Add Product',

...etc

if( rangemin(Column(2), Column(3),..etc ) = Column6, 'NUC') ))))))

And make sure all the parentheses match up

Re: Help with Ranking Multiple Expressions

Mon, 22 Apr 2013 07:29:45 GMT

Thank you Gysbert, it worked with a slight tweek

Used the following to counter the '-':

(Column(7)='Yes',

(RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))= num(Column(2)),vRank1,

(RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))= num(Column(3)),vRank2,

(RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))= num(Column(4)),vRank3,

(RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))= num(Column(5)),vRank4,

(RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))= num(Column(6)),vRank5))))))

Regards Rahul