Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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