Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mmilonas
Contributor
Contributor

Ignore Filter

Hi everybody,

maybe it is better in english.

I have a problem when I want to ignore specific filter.

I have 3 tables 

  1. SalesFacts
  2. Customer
  3. Calender

The salesfacts-table is the center of a star-scheme and connects the other two tables

(In real the setting is much more complicated but I'm trying to simplify it here.)

So what I want ist to show all customer despite what I click on the calender.

I tried allready the functions aggr() combined with only() like this:

aggr(only({<cal_year=>}customer,customer) ------ and some other variants

but it doesn't work.

Can somebody help me?

Thanx a lot!

Labels (1)
0 Replies