New to Qlik Analytics

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

Announcements
Join us on Sept. 17 to hear how our new GenAI Assistant empowers data professionals: REGISTER

Who Me Too'd this topic

marcobis
Contributor II
Contributor II

Let set analysis override filter selection

Hi all, I have a dimension on the first table with this definition:

=Aggr(Only({<ORDERS.YEAR = {2023},ORDERS.WEEK = {3}>}ORDERS.DAY),ORDERS.DAY)

there is a second table on the sheet that instead depends on a filter on ORDER.WEEK dimension.

I need those ORDERS.WEEK on the first table always remains 3 and ignores ORDERS.WEEK selection on the sheet. Any help would be appreciated.

 

Labels (5)
Who Me Too'd this topic