Qlik Community

New to Qlik Sense

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

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 

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