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: 
kbautist
Contributor II
Contributor II

Ignore filter

Hello experts ,

I have a data model just like the shown below:

kbautist_0-1677102178204.png

As you can see, I have a relationship between the column "Area" and almost all the tables that I have in my model.

The "Area" filter is the first one on my dashboard.

On the other hand, I had to create a data bridge and a master calendar for table 1, because I have two date columns that I needed to visualize in one chart. For that relationship, I have a canonical date from which I filter the information by date groups: "All to 30 days in the future" and "All to 60 days in the future." This is the second filter.

My issue is that when I filter by date, some of the "areas" don't have information for that date in Table 1, and because of that, all the tables remove that "area," even though those tables are not related to that filter because they don't have any date on them.

Do you know how I can ignore the "date" filter for all the other tables?

 

Thank you,
Regards

 

Labels (1)
1 Solution

Accepted Solutions
kbautist
Contributor II
Contributor II
Author

Hello everyone,

 

I solved the issue adding at the start of my chart formulas the {<Area=>}, using the set analysis.

Read more in here:

New Set Analysis syntax - Qlik Community - 1983110

A Primer on Set Analysis - Qlik Community - 1468344

 

Regards

View solution in original post

1 Reply
kbautist
Contributor II
Contributor II
Author

Hello everyone,

 

I solved the issue adding at the start of my chart formulas the {<Area=>}, using the set analysis.

Read more in here:

New Set Analysis syntax - Qlik Community - 1983110

A Primer on Set Analysis - Qlik Community - 1468344

 

Regards