Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I have productionID table , there records like product( a) to product (z) fields in my front end when i click on product b and product c selections should not take . it should be hide remaining should be work ? how?
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		SUM({1}Sales)
or
SUM(ALL Sales)
 
					
				
		
then use this expression:
sum({<product={'*'}-{'b','c'}>}value)
It helps.
 
					
				
		
 ThornOfCrowns
		
			ThornOfCrowns
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Is this the same question as http://community.qlik.com/thread/123384 which you posted five minures before?
 
					
				
		
sum({$<productid=-{'b','c'}>}measure)
 
					
				
		
difference is there between 2 queries
 
					
				
		
Hi,
like this sum({1-$<Product={'b','c'}>}Sales)
HTGH 
Ravi N.
 
					
				
		
correct brother. ekkada meeru undedhi
 
					
				
		
Hyd 
 
					
				
		
denilo chesthunnaru
