Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a table Like This:
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.
Go to Solution.
See the attached file...
See if this idea accomplish your require ...
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.
what is the require output?
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
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!
Inside the QVW you can find all expression used.
Thanks, That was what I wanted. with some adjustments I have achieved my goal!
Cannot open as I am having personal edition license.