Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
JohnPek
Contributor
Contributor

Displaying a message on a table if nothing is selected from the filter panel

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

Labels (2)
1 Solution

Accepted Solutions
MatheusC
Specialist
Specialist

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'

MatheusC_0-1710177703607.png

 

Regarts, Matheus



Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

2 Replies
MatheusC
Specialist
Specialist

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'

MatheusC_0-1710177703607.png

 

Regarts, Matheus



Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
JohnPek
Contributor
Contributor
Author

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.