Top and Bottom values in a single bar chart

Anonymous — Mon, 14 May 2018 09:07:31 GMT

Hi,

I have a requirement to show top 2 and bottom 2 markets in a single bar chart and both should be shown in different colours. I tried to implement this using rank function and conditional expressions but i am facing issues when the markets have same values and the top and bottom values are same.

1.) Is it a good idea to shown the top and bottom markets in a single chart? If no, do we have any alternatives.

2.) How can we resolve this issue if i go ahead with the current implementation.

Ex:

There are four expressions in my chart and 'Market' as a dimension.

First expression checks if the possible count of market is >3 and the ranks the markets and displays only those whose rank is <=2
Second expression checks if the possible count of market is >3 and the ranks the markets based on descending order and displays only those whose rank is <=2
Third checks if the possible count is >1 and <4 and ranks and displays only top value
Fourth checks if the possible count is >1 and <4 and ranks (des order) and displays only top value

topic Top and Bottom values in a single bar chart in QlikView

Top and Bottom values in a single bar chart