Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table Box -not change as selections are made (stay static)

Hi

I have a table box and want the information in it to stay static when I make selections.

The 2 columns are  : Team and %

If I select a team , the multi box adapts so that I only have the  % for that team. I would however like this multibox to remain constant so that it always keeps all the teams and %'s in the table. ( I am happy to change to a straight table, pivot etc if that is easier)

Thanks in advance

1 Solution

Accepted Solutions
Not applicable
Author

You can add set analysis to your formulas if you use a straight table. For example, if your formula is Sum(Sales), use Sum({1} Sales).  Now it will not be affected by your selections.

View solution in original post

2 Replies
Not applicable
Author

You can add set analysis to your formulas if you use a straight table. For example, if your formula is Sum(Sales), use Sum({1} Sales).  Now it will not be affected by your selections.

Not applicable
Author

Exactly what I needed!

Thanks