Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a line chart.
Dimension – location
Expression – readmit ratio
The location dimension has 7 values. So the chart has 7 lines by default.
The tab has only one filter – Location. When one location value is selected, I want to highlight the selected location in some bright color in the chart and other 6 lines should have grey color. All 7 lines should be still visible.
Please share your suggestions to achieve this.
Then see here for excellent guide:
https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/07/line-chart-tricks-part-two
I forgot to mention that location is 2nd dimension.
First dimension is Month year.
So, in the X axis we have months, Y axis we have ratio and chart has 7 line each corresponding to respective location.
You'll first need to load the Location as another, unlinked field such as 'Location Selector', otherwise it will remove the other locations from the chart.
Alternative to this is to include set analysis in chart expression if you want the location selector to affect the rest of the app.
Then see here for excellent guide:
https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/07/line-chart-tricks-part-two
wow! exactly what i was looking for. Thanks a lot. may god bless you