topic detaching a table with a filter in QlikView

detaching a table with a filter

Thu, 02 Jul 2015 09:22:38 GMT

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.

Re: detaching a table with a filter

alexandros17 — Thu, 02 Jul 2015 09:28:05 GMT

Use alternate states to do this.

Re: detaching a table with a filter

Gysbert_Wassenaar — Thu, 02 Jul 2015 09:28:34 GMT

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.

Re: detaching a table with a filter

Thu, 02 Jul 2015 09:36:33 GMT

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?

Re: detaching a table with a filter

Gysbert_Wassenaar — Thu, 02 Jul 2015 09:42:49 GMT

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)

Re: detaching a table with a filter

Thu, 02 Jul 2015 09:56:12 GMT

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.

Re: detaching a table with a filter

Gysbert_Wassenaar — Thu, 02 Jul 2015 10:00:13 GMT

remove the second set of parentheses after TOTAL:

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

Re: detaching a table with a filter

Thu, 02 Jul 2015 10:10:23 GMT

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

Re: detaching a table with a filter

Thu, 02 Jul 2015 10:19:50 GMT

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.

Re: detaching a table with a filter

Gysbert_Wassenaar — Thu, 02 Jul 2015 10:26:52 GMT

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

Re: detaching a table with a filter

Thu, 02 Jul 2015 11:42:11 GMT

In fact it would be a count of the number of product for a selected area (eg a state of the United States) and adjacent to the territories (eg the US).