Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
bebee727
Contributor II
Contributor II

Qlik Sense - Limiting Tables in 1 sheet

Hello,

I'm new to Qlik and I'm using Qlik Sense.  I'd like to limit one specific table in a Sheet to one Department.  I don't need restrictions at this time by members.  But only the table will display one departments data regardless of the selections made on other sheets.

Thanks

Bebee

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

If that table contains a measure then you can change the measure so the results are limited to that specific department. For example sum(Amount) would become sum({1<Department={'Entomology'}>}Amount).


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

If that table contains a measure then you can change the measure so the results are limited to that specific department. For example sum(Amount) would become sum({1<Department={'Entomology'}>}Amount).


talk is cheap, supply exceeds demand
bebee727
Contributor II
Contributor II
Author

Thank you !  That worked perfect!

Anonymous
Not applicable

Hi Bebee,

We're glad to see you were able to solve your issue. Please take a moment to Mark Replies as Correct or Helpful to give points to those who helped and to mark the thread as Answered.

Regards,

Qlik Community Team