Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
bebee727
Not applicable

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
Not applicable

Re: Qlik Sense - Limiting Tables in 1 sheet

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
3 Replies
Gysbert_Wassenaar
Not applicable

Re: Qlik Sense - Limiting Tables in 1 sheet

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
Not applicable

Re: Qlik Sense - Limiting Tables in 1 sheet

Thank you !  That worked perfect!

Community Manager
Community Manager

Re: Qlik Sense - Limiting Tables in 1 sheet

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