6 Replies Latest reply: Nov 28, 2014 7:12 AM by Matt Phillip RSS

    Where clause to be actioned via dashboard

    Matt Phillip

      I'm hoping someone may be able to help. Our institution has recently adopted Qlikview and we are in the process of compiling a draft pilot dashboard. We have a need to display certain information which requires the use of a WHERE clause to filter the results as using a list box or dragging over them will select additional records not required. The only way so far I've found to do this (my apologies as we only had our initial training last month), was a script:

       

      LOAD * FROM

      [V:\Qlikview\Test-Arts.xlsx]

      (ooxml, embedded labels, table is Sheet1)

      WHERE((Qual = 'HNC' And Year = '2') or (Qual = 'HND' And Year = '3'));

       

      Would someone be able to enlighten me on a solution which will mean the full table is loaded, but the WHERE clause is only actioned from the dashboard?

       

      Any help would be much appreciated!

       

      Matt