topic Pivot table filter in QlikView

Pivot table filter

Wed, 24 Nov 2010 20:05:03 GMT

Hi,

Is it possible to detach a Pivot table from one listbox filter.If so, how??

Thanks in advance.

Pivot table filter

johnw — Wed, 24 Nov 2010 20:16:36 GMT

One way would be to use set analysis in all of the expressions. So if your expression was this:

sum(Sales)

And you wanted to ignore the Country listbox for the pivot table, you could use this:

sum({<Country=>} Sales)

Pivot table filter

Wed, 24 Nov 2010 21:00:10 GMT

Hi John,

Thanks for your response.But still i am unable to get it work.

Here is the screnario.Below is the structure of the pivot table

Category	Products	Qty1	Qty2	Qty3
Cat1	Pdt1
	Pdt2
	Pdt3
	Pdt4
Cat2	Pdt1
	Pdt2
	Pdt3
	Pdt4

I would like to detach the pivot table on the Products listbox selection.

Thanks

Pivot table filter

johnw — Wed, 24 Nov 2010 21:09:13 GMT

If I understood your question, it works fine for me. See attached.

Pivot table filter

Wed, 24 Nov 2010 22:03:08 GMT

Thanks again john.

My fact is an expression, on adding the filter the fact data column becomes like '-'.

Pivot table filter

johnw — Wed, 24 Nov 2010 22:26:32 GMT

What do you mean by "my fact is an expression"? Are you saying that the Category or Product is actually a calculated dimension? Do you mean you have a list box that involves an expression, so you're trying to ignore an expression, not just a field? Really no idea what you're saying.

Maybe you could modify the example to demonstrate the problem?

Pivot table filter

Wed, 24 Nov 2010 22:52:25 GMT

Hi John,

The Q1,Q2 and Q3 values are not directly from the table column. I am doing some arithmetic operation to get those values and hence when i add the filter its not working and just display's '-'.

Pivot table filter

johnw — Wed, 24 Nov 2010 23:08:24 GMT

OK. What expressions are you using?

Pivot table filter

Mon, 29 Nov 2010 19:15:56 GMT

Hi John,

Thanks for your solution it worked.

I was actually using something like $(eQty),where $(eQty) = sum(volume)* sum(buckets).I had to use sum({<Products=>}volume)*sum({<Products=>}buckets). but i was trying to use sum({<Products=>$(eQty).