detaching a table with a filter

[#1]

Hello,

Is it possible to detach a table with a filter. Indeed, a filter is applied on the sheet but I would like for one of the tables it is not.

Thank you.

[alexandros17]

Use alternate states to do this.

[Gysbert_Wassenaar]

You can create an alternate state on the General tab of the Document Properties window and then assign that alternate state to the table object on the General tab of the properties window of the table object.

[#4]

In fact, I try to make a table with two columns. The first count products for a selected area and the second takes the total of all products.

I'd like to do that in one table but I don't know how to do. Could you help me?

[Gysbert_Wassenaar]

In a straight table you can use set analysis expressions and override selections:

Don't override user selections: count(distinct products)

Override the selection of area: sum({<area=>} salesamount)

[#6]

My formula is following for a ratio:

=count({<[area]>} [No product])/count(TOTAL({<[area]>} [No product]))

The first part of the formula works because I tried it alone. The second no apparently.

[Gysbert_Wassenaar]

remove the second set of parentheses after TOTAL:

=count({<[area]>} [No product])/count(TOTAL{<[area]>} [No product])

[#8]

thank you enormously for all the answers. I still think I will need your help to other problems.

[#9]

Last question and then I'll leave you. I would like always the table but in the following form:

Products sector          Area                    His country to the selected area

Sector 1

....

Total

Thank you.

[Gysbert_Wassenaar]

I don't understand the question. Can you post a qlikview document that explains it?