11 Replies Latest reply: Sep 19, 2018 3:10 AM by Thomas Ødegaard RSS

    Highlight with colors instead of filtering the chart

    Thomas Ødegaard

      Hi,

      I would like to highlight columns in a column chart based on a selection you make from another table.

       

      Example:

      If I select KPI B in the table in the picture attached, I would like the right bar chart to highlight columns for 201806 and 201808 (as this is the corresponding YearMonths in the table) with a red color instead of filtering the chart.

      The same way if you choose the comment in row 3 in the table, I would like the right bar chart to highlight column for 201808 (as this is the corresponding YearMonth in the table) with a red color instead of filtering the chart.

      If nothing is selected in the table, the chart should be as it is in the picture.

       

      This is fairly easy done in Tableau and Power BI, but how is it made in Qlik Sense?

       

      I have also attached my dummy data as an Excel file and the application.

       

      I hope you can help.

       

      Br,

      Thomas