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

How to display only certain data in a table?

Tue, 09 Apr 2013 12:58:33 GMT

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

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

Tue, 09 Apr 2013 17:39:45 GMT

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

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

Tue, 09 Apr 2013 18:03:07 GMT

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