Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor

Re: Rank with a dimention that is not in the chart

See the attached file...

12 Replies
jolivares
Valued Contributor

Re: Rank with a dimention that is not in the chart

See if this idea accomplish your require ...

Not applicable

Re: Rank with a dimention that is not in the chart

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.

Re: Rank with a dimention that is not in the chart

what is the require output?

Not applicable

Re: Rank with a dimention that is not in the chart

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
Valued Contributor

Re: Rank with a dimention that is not in the chart

See the attached file...

Digvijay_Singh
Honored Contributor III

Re: Rank with a dimention that is not in the chart

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
Valued Contributor

Re: Rank with a dimention that is not in the chart

Inside the QVW you can find all expression used.

Not applicable

Re: Rank with a dimention that is not in the chart

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

Digvijay_Singh
Honored Contributor III

Re: Rank with a dimention that is not in the chart

Cannot open as I am having personal edition license.

Community Browser