Legends in Bar Graph

[#1]

Hi All,

I have created a Bar chart where the Y Axis is a calculated Measure (Using an expression), a % field. Lets keep the name of this field as 'Sales %'.

I want to differently colour code where Sales is <= 10% and > 10%. I want these two custom categories to be shown as Legends, so that the end user can simply click the > 10% to see the sales in that category.

Is there a way to do this?

[viveksingh]

Hi Chandran,

under "Colors and Legend" option, change color to Custom and select "By Expression" option.

here you can write your expression like,

if(Sales % >10,Green(),Red())

Thanks,

Vivek

[shubham_singh]

Allow users to select a range of % by using qlik's inbuit functionality like this.

OR calculate % in back end and add a second dimension to bar chart like this.

[#4]

I have tried this option, But, this does not display the legends where the user can simply click and filter the results.

[#5]

I am aware of this option. I am looking at an option in the bar chart, where users can filter in a click of a button. Hence, looking to display the legend > 10%.

[#6]

You'll have a create a new dimension for filtering.

[shubham_singh]

See my second screenshot, it has legends.