Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank with a dimention that is not in the chart

Hi,

I have a table Like This:

                                                                                                                            

CompanyYearRatioValue
CEUJ2011Ratio15593525
CEUJ2012Ratio15367548
CEUJ2013Ratio15544482
CEUJ2014Ratio14875582
CEUJ2015Ratio11714342
CEUJ2011Ratio22494074
CEUJ2012Ratio21661454
CEUJ2013Ratio28148792
CEUJ2014Ratio28200381
CEUJ2015Ratio28190812
DOGD2011Ratio13451768
DOGD2012Ratio12334441
DOGD2013Ratio16271079
DOGD2014Ratio14344662
DOGD2015Ratio18181262
DOGD2011Ratio25350576
DOGD2012Ratio21177257
DOGD2013Ratio25170544
DOGD2014Ratio26574504
DOGD2015Ratio26693989

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.

1 Solution

Accepted Solutions
jolivares
Specialist
Specialist

See the attached file...

View solution in original post

12 Replies
jolivares
Specialist
Specialist

See if this idea accomplish your require ...

Not applicable
Author

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:

Untitled.png

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?

Not applicable
Author

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
Specialist
Specialist

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
Specialist
Specialist

Inside the QVW you can find all expression used.

Not applicable
Author

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.