How to apply filter for multiple pages with different data tables.

[Vijesh]

Hi Team,

Is it possible to apply filter on Page1 and filter must apply to all Pages i.e Page1, Page2, ..Page n. Each page has it's own data table. The data tables are SQL queries.

Data table1 query is like select col1,col2,col3,col4,col5 from table1; Using this Page1 visualization are created.

Data table2 query is like select col1,col6,col7,col8,col9 from table2; Using this Page2 visualization are created.

Data tablen query is like select col1,col50,col51,col52,col53 from tablen;  Using this Pagen visualization are created.

The common column in all tables is col1 and rest of the columns are different. Not joining the tables using col1 to form 1 single data table as records are coming in billions. So created separate data tables for each page and visualizations are created for each page.

As filters we have  col1,col2,col3, col6,col7,col50, col51. Now if apply filter on col2 then what ever the col1 records get filtered on page1 the same col1 records must filter in Page2 ... Pagen.

For all the queries the where condition is common i.e col1 In (1,2,3,4,5,6,7,8,9,10...n), The values with in condition will change for each run i.e col1 in (4,5,6,7) is possible col1 in (1,2,3,4,5), col1 in (5,6,7,8)...etc

For example if in 1st set the condition is (1,2,3,4,5,6,7,8) then applying col2 filter results in col1 values 1,2,3,4,5,6. Then in page2 ...pagen as well col1 must be 1,2,3,4,5,6. Further if in Page2 col6 filter is applied and col1 values comes as 1,2,3,4 then in all pages col1 must be 1,2,3,4. If we clear col2 filter then col1 in all pages must be 1,2,3,4,5,6. If we remove col1 filter then col1 in all pages must be 1,2,3,4,5,6,7,8.

Edited Thursday at 02:51 PM by Vijesh

[David Boot-Olazabal]

Hi Vijesh,

Each visualization has a filtering scheme attached to it via Properties --> Data tab:

If you use the same scheme for your visualizations on the different pages, whenever you filter out on col1, it should affect the other visualizations as well.

On top of that, you can also filter in related tables (you have to relate the data tables first though). This would allow data table1 filter 1 to affect other data tables as well (and along with that, their visualizations):

More information on Filters can be found via the Help menu (Help Topics).

Kind regards,

David

[Vijesh]

Hi David,

Thanks for your Inputs.

I have Related the data tables (demo & summary) with Case ID through 'Manage' Relations' as shown below. I then selected '13957155' Case ID from 'demo' filter. But in the output only for Demo Visualization the filter got applied, in summary Visualization I can all the case ID's (in screen shot you can see 15309436 is also coming along with 13957155). So looks the filter is not getting applied for Summary visualization/data table even though data tables are related. Let me know if I am missing something here.

 

                

 

Thanks,

Vijesh

[David Boot-Olazabal]

Hi Vijesh,

Can you share your dxp file, so we can have a close look at the setup?

Kind regards,

David

[Vijesh]

Hi David,

After performing below I am able to achieve.

Referred the link https://support.tibco.com/external/article?articleUrl=How-to-use-one-filter-to-control-two-tables-in-TIBCO-Spotfire

Thanks,

Vijesh