topic Re: Line chart in QlikView

Line chart

reshma_km — Tue, 28 Jun 2016 08:53:52 GMT

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.

Re: Line chart

reshma_km — Tue, 28 Jun 2016 08:56:12 GMT

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.

Re: Line chart

juleshartley — Tue, 28 Jun 2016 09:31:02 GMT

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.

Re: Line chart

juleshartley — Tue, 28 Jun 2016 09:42:33 GMT

Then see here for excellent guide:

https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/07/line-chart-tricks-part-two

Re: Line chart

reshma_km — Tue, 28 Jun 2016 09:53:29 GMT

wow! exactly what i was looking for. Thanks a lot. may god bless you