Display table based on user selection

[jjustingkm]

I am trying to display a table in the dashboard if the user selects at least one filter in the dashboard. But the option I came across is to select based on a field in Data Handling section like below. I would try to limit not specifying the filed but instead if any filter is selected on the dashboard.

GetSelectedCount([PRODUCT ID)

or

GetSelectedCount([REGION ID)

[Lech_Miszkiewicz]

Hi. 

If you want to know if any selection is applied you can use GetCurrentSelections function and workaround it. Parameters are as follows:

GetCurrentSelections ([record_sep [, tag_sep [, value_sep [, max_values [, state_name]]]]])

https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Field...

just note that hidden fields selections will not be visible, but for those you can use functions you already mentioned. 

cheers

[Vegar]

If hidden fields are an issue then you could also compare a measure (pick one that will change on any selection) of the current selections with measure of the full dataset. 

=if(count({$}id) = count({1}id) , 0,1)

[jjustingkm]

I think I was looking for something like this.

Len(GetCurrentSelections())

[marcus_sommer]

I would use a count as condition against the main-dimensions of the table, maybe something like:

count(distinct [PRODUCT ID] & [REGION ID]) < 21

and regardless which selections are made the condition will limit the table effective (at least if the data are sensible associated in the data-model).