Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.
I have tried this option, But, this does not display the legends where the user can simply click and filter the results.
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%.
You'll have a create a new dimension for filtering.
See my second screenshot, it has legends.