topic Displaying a message on a table if nothing is selected from the filter panel in App Development

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

JohnPek — Fri, 15 Nov 2024 21:02:06 GMT

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.

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

MatheusC — Mon, 11 Mar 2024 17:22:21 GMT

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

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

JohnPek — Mon, 11 Mar 2024 18:06:51 GMT

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.