Rank with a dimention that is not in the chart

[#1]

Hi,

I have a table Like This:

Company	Year	Ratio	Value
CEUJ	2011	Ratio1	5593525
CEUJ	2012	Ratio1	5367548
CEUJ	2013	Ratio1	5544482
CEUJ	2014	Ratio1	4875582
CEUJ	2015	Ratio1	1714342
CEUJ	2011	Ratio2	2494074
CEUJ	2012	Ratio2	1661454
CEUJ	2013	Ratio2	8148792
CEUJ	2014	Ratio2	8200381
CEUJ	2015	Ratio2	8190812
DOGD	2011	Ratio1	3451768
DOGD	2012	Ratio1	2334441
DOGD	2013	Ratio1	6271079
DOGD	2014	Ratio1	4344662
DOGD	2015	Ratio1	8181262
DOGD	2011	Ratio2	5350576
DOGD	2012	Ratio2	1177257
DOGD	2013	Ratio2	5170544
DOGD	2014	Ratio2	6574504
DOGD	2015	Ratio2	6693989

then I have a Chart with Year & Ratio as Dimension & Value for One Company as Expression.

Now, What I want is to show rank of Company in given Year & Ratio as Expression in Chart described above.

I prefer not to change dimensions and to have just one expression. since it affects chart coloring.

Any Idea on How to accomplish this??

Thanks in Advance

BTW I have attached my sample file.

[jolivares]

See if this idea accomplish your require ...

[#3]

Thanks for the reply but actually I didn't get what was the aim of those expressions u added. it just added bunch of ones & twos at bottom of my chart.

let me clarify my question:

this is a table I got from qlikview using my sample data:

I calculated the rank column by simple Rank formula with Year, Ratio & Company as dimension.

Now my problem is in the chart I cant add company as dimension & I have to filter it in expression.

in other words, I want to have the green numbers in my chart without adding company as dimension.

Please refer to the file I attached.

[Kushal_Chawda]

what is the require output?

[#5]

I want to have the green numbers in the table above to show up in my chart without adding company as dimension. I have created the chart I want in the excel I attached

[jolivares · Accepted solution]

See the attached file...

[Digvijay_Singh]

Hi Juan,

I was following this post to know more on how to achieve it, having PE so cannot see the expression, can you share the expression used, thanks in advance!

DJ,

[jolivares]

Inside the QVW you can find all expression used.

[#9]

Thanks, That was what I wanted. with some adjustments I have achieved my goal!

[Digvijay_Singh]

Cannot open as I am having personal edition license.