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

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

Mon, 04 Feb 2013 20:09:05 GMT

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

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

Mon, 04 Feb 2013 21:34:00 GMT

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.

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

Tue, 05 Feb 2013 09:47:10 GMT

Exactly what I needed!

Thanks