topic Re: Using attribute filters from one data set to another data set in QlikView

Using attribute filters from one data set to another data set

Wed, 24 Jun 2015 16:14:56 GMT

Hi,

I have two datasets in QV and I join them using the columns A & B. The first table is used to build a summary view and the 2nd table is used to build a detailed view. Columns C & D are used as dimensions on the summary view and I want to use the C & D column filters to apply to detailed view using columns E and F as the data values in these columns match.

Should I be building a column mapping table of some sort?

Re: Using attribute filters from one data set to another data set

ecolomer — Wed, 24 Jun 2015 16:19:14 GMT

see this example

Re: Using attribute filters from one data set to another data set

Wed, 24 Jun 2015 16:25:38 GMT

Enrique,

This looks very close to what I am trying to do but in my case the two tables are also joined together using columns A and B. I'll try and see if a variation would work in my case.

Also the detailed view is a straight table where columns from table 2 have been added as dimensions.

Re: Using attribute filters from one data set to another data set

Anonymous — Wed, 24 Jun 2015 16:41:53 GMT

If the tables are joined shouldn't C and D already be associated with E and F?

Re: Using attribute filters from one data set to another data set

Thu, 25 Jun 2015 08:29:58 GMT

Michael,

They are but the join is on A and B but we need filters on the values from columns C and D to be available for values from columns E and F.