Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 qlik4asif
		
			qlik4asif
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I want to find the Manufacturers whose sales are over 100,000 for the 2 categories CHEESE CAKE and ACC in January 2013 (period P01/13). But I want to remove from that list those whose sales are lower than 50,000 for all categories in January 2012:
write set analysis code for this
I tried with this
Only({<Sales={">100000"},categories={'CHEESE CAKE' ,'ACC' },period={'P01/13'}>-<Sales={"<50000"},categories={*},Period={'P01/12' } >Manufacturers})
Can some one correct this expression.
Thanks in advance
What Only(Manufacturers) returning?
 isingh30
		
			isingh30
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Only({<Sales={">100000"},categories={'CHEESE CAKE' ,'ACC' },period={'P01/13'} - Sales={"<50000"},categories={*},Period={'P01/12' }>}Manufacturers)
 isingh30
		
			isingh30
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you share your data in excel format?
 qlik4asif
		
			qlik4asif
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Yes Anil, need Manufacturers who satisfies above condition.
