Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
MeeraAgrawal
Creator
Creator

Dependent Filter

Hi Guys 

I have two excel sheet one is having country wise data and other are state wise, and Country field is common to both sheet. and I have made two sheet in Qlik sense one having country wise and other is state wise .When I am applying filter to country then go to state wise sheet it's taking only one state Andhra Pradesh not all the state of India. why it's happening?

1 Solution

Accepted Solutions
kaushiknsolanki

Because both the excel is linked based on the country field.

If you don't want them to link, change the name of the country field from any one table.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

2 Replies
kaushiknsolanki

Because both the excel is linked based on the country field.

If you don't want them to link, change the name of the country field from any one table.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

MeeraAgrawal
Creator
Creator
Author

Hi @kaushiknsolanki 

Thanks its working now ,but my question is that if I have multiple table and each table having country field to make relation b/w them we need to edit all the country name i.e, unique column field name?