2 Replies Latest reply: Apr 9, 2013 2:03 PM by Yusuf Ali RSS

    How to display only certain data in a table?

      Hi there,

       

      I have what I think is a simple question, but I can't come up with a solution for it due to my lak of knowledge of coding QlikView.  I'm hoping someone can help me out here.

       

      I have a table (data populates it from a web export).  The data has 3 columns (date,sample,name), and I need to be able to tell the table to ONLY display the data that has a certain name (string) in it (or even part of a name) - let's say names I have are Jason, and I have Jack, so I want to be able to tell it to display everying with "Ja*".

       

      Here is a copy of the chart :

       

      DATE               SAMPLE               NAME

      01-01-13          ca123                    jason

      01-01-13          ca124                    bob

      01-01-13          cf111                      bill

      01-01-13          ci1598                    jack

      01-01-13          cf112                      bob

      01-01-13          ci1599                     jason

       

      Any ideas?

       

      I can post a picture of my table if that would help..

       

      thanks,

       

      -hp