topic Re: Display table based on user selection in App Development

Display table based on user selection

jjustingkm — Tue, 03 Mar 2026 21:33:58 GMT

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)

GetSelectedCount([REGION ID)

Re: Display table based on user selection

Lech_Miszkiewicz — Wed, 04 Mar 2026 03:38:19 GMT

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/FieldFunctions/getcurrentselections.htm

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

cheers

Re: Display table based on user selection

Vegar — Wed, 04 Mar 2026 05:54:29 GMT

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)

Re: Display table based on user selection

jjustingkm — Wed, 04 Mar 2026 14:35:05 GMT

I think I was looking for something like this.

Len(GetCurrentSelections())

Re: Display table based on user selection

marcus_sommer — Thu, 05 Mar 2026 16:21:26 GMT

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).