topic Re: Limiting data in qliksense table to a certain dataset or field value in App Development

Limiting data in qliksense table to a certain dataset or field value

lisab80 — Wed, 29 Apr 2026 10:18:32 GMT

I would like to be able to choose the dataset being read into a table in qliksense.

There are 4 datasets being read into my app. Lets calls these sources Dataset1, Dataset2, Dataset3 and Dataset4.

To differentiate these datasets I have a source field within each dataset Dataset1_Source = Set1, Dataset2_Source = Set2 and so on

I then use a link table to combine this field for all datasets and call that field Source so it now contains the values Set1, Set2, Set3, Set4.

I would like to be able to have a table in my app that when the app opens only contains data from Set2 and Set4.

I have tried to limit my table using this expression in my measure but unfortunately that does not work - when I open my table and filter on the source I can still pick the other options although when selected they return nothing. I would like a way that when my app opens the table only has data from these two datasets so the user can only pick Set2 or Set4 from the Source field. I want to include the source field in my table output as I would like the user to be able to toggle between Set2 and Set4.

sum({<Source={'Set2', 'Set4'}>}Counter)

Any help appreciated

Re: Limiting data in qliksense table to a certain dataset or field value

BIAKS — Wed, 29 Apr 2026 10:45:20 GMT

Hello,
If you want specific users to access limited data you can use section access, help. If you want everyone to access only Set2 and Set4, do a where condition on your final table in the script. You can also use the set analysis outside of the expression ( {< Source = {'Set2','Set4'} >} Sum(Counter) ) and hide the null values in every dimension but this doesn't limit the user selecting data from elsewhere.

Re: Limiting data in qliksense table to a certain dataset or field value

NitinK7 — Wed, 29 Apr 2026 10:47:42 GMT

Hi,

Without looking app its hard to say anything...

But you can try to creating using flag in each table like

'Set1' As Flag,

and then use flag in your expression

sum({<Flag={'Set2', 'Set4'}>}Counter)

Re: Limiting data in qliksense table to a certain dataset or field value

Daniel_Castella — Wed, 29 Apr 2026 11:12:47 GMT

Hi @lisab80

This cannot be done directly, but I think there is a tricky way to recreate the behavior:

1. In the script, create a Flag field to be 1 when Source = Set2, Set4; and 0 when Source = Set1, Set3

2. Write the name of that field with a prefix and then hide it using SET HidePrefix = '_'; (you can use other indicator apart from _ , this is only as example).

3. In the sheet, create an action on opening to select the value 1 on that Flag field.

4. Create another action to Lock the selections on the Flag field.

This will make the users to always be forced to choose Set2 and/or Set4 since if they click on Set1 or Set3, the Flag field should change but we locked it. So, Qlik will not make that selection. Also, since the Flag field is hidden, the users will not be able to unlock it.

Let me know if you need clarifications in some step.

Kind Regards

Daniel

Re: Limiting data in qliksense table to a certain dataset or field value

lisab80 — Thu, 30 Apr 2026 10:30:30 GMT

Hi BIAKS

Many thanks for the reply I tried what you suggested above. So in my table under each dimension I selected show column if

( {< Source = {'Set2','Set4'} >} Sum(Counter) ) then unticked include null values for very dimension in the table

That doesn't work when I open the sheet with the table the source field still shows all the other datasets as selectable values (although when you pick them there is no data) - I would like the source field to only have dataset2 and dataset 4 as selectable from the source field and the other values either greyed out as unelectable or not in the field at all.

Re: Limiting data in qliksense table to a certain dataset or field value

lisab80 — Thu, 30 Apr 2026 10:31:34 GMT

Hi NitinK7

many thanks for the reply thats what I was doing against my measure in the table but it didnt limit the data in the table.

Re: Limiting data in qliksense table to a certain dataset or field value

lisab80 — Thu, 30 Apr 2026 10:33:00 GMT

Hi Daniel

Many thanks for your reply. What you suggest above does work but when I got from table to table this locked selected still applies

Is there a way that when you leave that sheet it will remove the filter then when you open it again it will apply the filters again?

Re: Limiting data in qliksense table to a certain dataset or field value

Daniel_Castella — Thu, 30 Apr 2026 10:51:50 GMT

Hi @lisab80

I think you cannot apply actions when leaving the sheet in Qlik Sense. But what you can do is set in the other sheets an action on opening unlocking the fields and clearing the selections you need. This will make the same effect, the bad part is that you will need to set the actions to every sheet.

Kind Regards

Daniel

Re: Limiting data in qliksense table to a certain dataset or field value

lisab80 — Thu, 30 Apr 2026 16:16:15 GMT

Thanks for the help and advice Daniel - that solution will definitely work