7 Replies Latest reply: Dec 12, 2016 5:31 AM by Marcio Arruda RSS

    How do you filter chart data by a field in a List box.

    Trevor Perks

      Hello and thank you for reading this.

       

      I am new to QlikView and would like to know how I use a selection item in a List Box to filter data I have in a Chart.

       

      In my Script I have loaded in a single Filter dimension

       

      DimensionsForFilter:

      LOAD

      *

      INLINE [

      FilterDimensions

      'Project Is Active'

      ];

       

      Then I have a List Box that has the 'Project Is Active' from the FilterDimensions.

       

      I have a chart that has a LED presented field of 'Project is Active' that is showing its value of 'Yes' or 'No', but i would like to only show result lines for those items with a value of 'Yes' if the FilterDimensions selection 'Project Is Active' is clicked and activated.

       

      Man Thanks