Qlik Sense filter values based on another filter selection

[piyush_s11]

Hi Team,

I have a requirement where I have two dimensions in two different sheets. Requirement is if I select any values in 1 dimension it should also apply same values in another filter.

The two dimensions are from two different tables which are not associated. It is the requirement that two tables should not have association between them. They should be treated as separate tables.

Please find below data model.

In above, requirement there are two filters in two sheets one is issue_id & another is kanban_issue_changelog.issue_id.

Now if I apply filter on 1 sheet on issue_id then same values should be filtered and applied in another sheet for kanban_issue_changelog.issue_id filter.

Please Note : Association is not the requirement. The two tables should be treated separately. 

Kindly Help.

Thanks.

@avinashelite @kushalthakral @tresesco @prabir_c @eliran @Anil_Babu_Samineni @MayilVahanan @its_anandrjs @anbu1984 

[vamsee]

See 
Copy Selections from one field to another - Qlik Community - 614488

[vikasmahajan]

Hi,

you can do one thing you can load manual dimensions like following:

Dims:

Load * inline  [

Dimension_Changelog

Project_id,

Project_name,

Issue_id,

... etc

];

associate Dimension_Changelog in another table

Epic_changelog:

Load * inline [ 

Dimension_Changelog,kanbanissuechglog

Project_id, kanban.Project_id

Project_name,kanban.Project_name

Issue_id,kanban.Issue_id

..

Etc

];

this will associate in your data model.

Vikas