Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I have three charts (Chart1, Chart2, Chart3) and 7 filters (Filter1, Filter2, Filter3, Filter4, Filter5, Filter6, Filter7).
Chart1 should be affected by all of the filters.
Chart2 and Chart3 should only be affected by Filter1, Filter2, Filter3.
So, for example, if i make a selection in Filter1, all of my charts should be affected. If i make a selection in Filter4, only Chart1 should be affected while Chart2 and Chart3 should stay the same.
Can you please advise of any solution how i can do this?
Thanks!
 lorenwood
		
			lorenwood
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Instead of Alternate States you may want to do something like this:
I have three charts (Chart1, Chart2, Chart3) and 7 filters (Filter1, Filter2, Filter3, Filter4, Filter5, Filter6, Filter7).
For Chart 1, do not need to do anything
For Chart 2 & 3 in set analysis you can do (example)
sum({< Filter4=,Filter5=,Filter6=,Filter7= >} Value)
So if any selections for Filter 4-7 are made they will not affect Chart 2 and 3. They will affect Chart 1 per your requirement.
 
					
				
		
With Alternate States for comparative analysis.
Look at this document:
Hope this helpshttp://www.resultdata.com/using-alternate-states-in-qlikview-11/
 lorenwood
		
			lorenwood
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Instead of Alternate States you may want to do something like this:
I have three charts (Chart1, Chart2, Chart3) and 7 filters (Filter1, Filter2, Filter3, Filter4, Filter5, Filter6, Filter7).
For Chart 1, do not need to do anything
For Chart 2 & 3 in set analysis you can do (example)
sum({< Filter4=,Filter5=,Filter6=,Filter7= >} Value)
So if any selections for Filter 4-7 are made they will not affect Chart 2 and 3. They will affect Chart 1 per your requirement.
 
					
				
		
Thank you very much! It worked!
 lorenwood
		
			lorenwood
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Glad i could help
