Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator
Creator

Common filter for multiple data set

i have 3 data sets like below. I need to provide an indicator filter that will have values 'Y' and 'N' using the third data set.  When select 'Y' it select only sales and order for a and b, when select 'N' select value for c and d. 

Sales       Order     Indicator  
Region  sales     Region  Order   region IND
a 30     a 60   A Y
b 30     b 50   B Y
c 80     c 80      
d 30     d 30      

 

Labels (1)
1 Reply
Vegar
MVP
MVP

Is it the different use of UPPER sn lower case letters in your key  data and field name that is the issue?

Try loading the indicator data like this:

LOAD lower(region) as Region, IND FROM  indicatorSource;