Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hello Team,
I am new to Qlikview, can you help me on the below, where the where match function not working, is there any changes to be done in the script.
Directory;
LOAD Product_Id,
Product_Line,
Product_category,
Product_Subcategory
FROM
[Match Function.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
Where match(Product_Line, 'Food','Sporting Goods')
 
					
				
		
 devarasu07
		
			devarasu07
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		HI,
it's correct only, can you share your data. thanks
also check this article
 trdandamudi
		
			trdandamudi
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you provide sample data please... It will be helpful to understand and give you a solution. I do not see any issue on the code you pasted. Here is a quick example that will work:
Data:
 Load * Inline [
 Product_Id,Product_Line,Product_category,Product_Subcategory
 100,Food,Cat1,SubCat11
 200,Sporting Goods,Cat2,SubCat22
 300,Balls,Cat3,SubCat33
 ];
 
 NoConcatenate
 Final:
 LOAD Product_Id, 
 Product_Line, 
 Product_category, 
 Product_Subcategory
 Resident Data
 Where match(Product_Line, 'Food','Sporting Goods');
 
 Drop Table Data;
 
This condition should work, But Qlik is Case Sensitive. You have to initiate proper names in your Condiytion..
 
					
				
		
 vishsaggi
		
			vishsaggi
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		how are your values in your Product_Line field? may be use Wildmatch().
 
					
				
		
 Colin-Albert
		
			Colin-Albert
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		There are several versions of the match function depending on whether you are doing a an exact match, a case insensitive match or a wildcard match.
Have a look at
match()
mixmatch()
wildmatch()
can any one explain mixmatch,wildmatch with example?
There is also a useful video on Qlikshare (search for Match) http://qlikshare.com/
 shiveshsingh
		
			shiveshsingh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you share data? it would be better if we check using your data and find the error..
 
					
				
		
Thanks verymuch its clear now
