Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 krishna789
		
			krishna789
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		i have 5 text box
1 past due
2 expedite
3 hot
4 in-transit
5.not picked up
each text box has one table ,in text box i use =if(GetSelectedCount(CustomerName) = 1 , Count( DISTINCT {<PShipment=>}PShipment), similar each text box .i gave variables in layout of table so that if we press past due text box will come.similarly reamining and count of customer will shown .but while selecting one customer it should become value 1
my question is for example when i am selecting one customer id like past due reamining box value also changing like expedite ,hot....
how restrict reaming text box values
 
					
				
		
 pradosh_thakur
		
			pradosh_thakur
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi
This is how associative property of QLIKVIEW works.When you select something the associated value will be white or grayed if not associated. It will not effect your getselectedcount value of the other filters.
regards
Pradosh
 
					
				
		
 andrei_delta
		
			andrei_delta
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hello,
maybe in set analysis you can put 1 because - "Represents the full set of all the records in the application, irrespective of any selections made."
Regards,
Andrei
 
					
				
		
 krishna789
		
			krishna789
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi
actually taking {1} is good but problem is {1} is taking all shipments but i want for only each customer shipments in pastdue ,hot,..etc.
 
					
				
		
 pradosh_thakur
		
			pradosh_thakur
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		try using p() function in your expression
 
					
				
		
 krishna789
		
			krishna789
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi
thanks for your response .my equation is = if(GetSelectedCount(CustomerName) = 1 , Count( DISTINCT(PShipment) ,so i am not using set analysis.
 
					
				
		
 pradosh_thakur
		
			pradosh_thakur
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		can you post your sample app?
