Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.