Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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

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