Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 JohnPek
		
			JohnPek
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi everyone,
I have a conditional table that is required to select fields from the filter panel to show results. Please see the attached screen shot. The filter panel is created from an island table by using inline loading. Then I created variables to use them in column section "Show column if". For instance;
Created variable
Name: v_ShowRegion  ||  Definition: =if( wildmatch ( GetFieldSelections (Desc, ',',500), '*Region*'), 1, 0)
Putting v_ShowRegion inside the "Show column if" property area for Region dimension.
I do have multiple dimensions like above. 
Basically, in a visual perspective I need to have a writing on the table "Please select a field from the filter panel on left side" instead of Incomplete Visualization. I appreciate for your help.
Qlik Sense Business
 
                
            
         MatheusC
		
			MatheusC
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi, @JohnPek
You can put a condition to display the table and message in Data Handling
Enter a display condition, calculation condition
GetSelectedCount(Field)>=1
Displayed message 
'Message to show'
Regarts, Matheus
 MatheusC
		
			MatheusC
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi, @JohnPek
You can put a condition to display the table and message in Data Handling
Enter a display condition, calculation condition
GetSelectedCount(Field)>=1
Displayed message 
'Message to show'
Regarts, Matheus
 JohnPek
		
			JohnPek
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi @MatheusC,
I used the data handling part with the multiple variables I created for filtering.
v_ShowRegion>=1 or v_ShowCountry>=1 or .. it worked perfectly.
Thank you very much for your help.
