Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

2 Replies
Not applicable

Re: How to display only certain data in a table?

woohoo... I figured it out using the left() variable.

Under "Used Dimensions" I added the following :

=if(left([NAME],2) = 'ja',Date5)

the Date5 is just a variable I display as a result.

Hope this helps someone else as well.

-hp

Not applicable

Re: How to display only certain data in a table?

Hi ,

      Your solution is correct but in some circumstances it may not give the desired output.

If the there is name like 'AndrewJackson' then the Left keywod wont help.

You can better try to  have wildmatch( ).

Ex :

Load Date , SAMPLE , Name From [....]

where  wildmatch( Name , '*ja*' ) >0 .

Thanks

Community Browser