topic Detaching tables in QlikView

Detaching tables

Wed, 30 Jan 2013 15:25:14 GMT

Is it possible to detach a table only from 1 specific table

for e.g. lets say i have a pivot table and multiple filters.

i want all my filters to affect the table except 1 filter

is it possible to detach my pivot only from the 1 filter ?

rwunderlich — Wed, 30 Jan 2013 23:11:26 GMT

You can use set analysis in your expressions to ignore selections in a specfic field. For example, if you wanted to ignore any selections in Year:

sum( {<Year=>} Sales)

-Rob

Thu, 31 Jan 2013 13:24:25 GMT

It did not work

let me elaborate

I have a dimension PDF names in a pivot table

I have another dimension 'Product Names' in a list box

i am sourcing from excel

Since the list names are not categorised as per products, the moment someone selects a product, the pdf pivot goes blank

how can i avoid this ?

rwunderlich — Thu, 31 Jan 2013 15:49:43 GMT

Did you try {<product=>} in yout Pivot Table expressions?

-Rob