Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Help with Ranking Multiple Expressions

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

RL

1 Solution

Accepted Solutions

Re: Help with Ranking Multiple Expressions

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


talk is cheap, supply exceeds demand
3 Replies
Not applicable

Re: Help with Ranking Multiple Expressions

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

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


talk is cheap, supply exceeds demand
Not applicable

Re: Help with Ranking Multiple Expressions

Thank you Gysbert, it worked with a slight tweek

Used the following to counter the '-':

IF

(Column(7)='Yes',


if

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


if

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


if

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


if

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


if

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

Regards Rahul

Community Browser