4 Replies Latest reply: Nov 3, 2009 11:38 AM by jonnyu182 RSS

    Its a filter but not as I know it.

    jonnyu182

      Morning all,

       

      I am still learning my way with Qlikview and have managed to exceed my know how once again.

      I have created a table and would like to filter it by a certain data type. However I do want to use the "Sheet" filter things as this would limit other tables on the sheet that i still need to show the other data.

      So my question is.. How can i filter a table to only show certain records.

      The SQL equivilent would be

      [Code] SELECT [Job Name] FROM tbl_Example WHERE JobType = 'INB'[/Code]

      Also the icing on the cake would be for the field i am trying to filter 'JobType' not to be displayed in the result set.

       

      Regards

      Jonny.