Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
G3S
Creator III
Creator III

Ignoring one filter selection and keeping others

hi

there is set analysis used in a straight table. There will be multiple dimensions filtered on. however, one of them needs to be ignored for this measure . dimension to be ignored = Forwarder.

set analysis:

Sum({$<AFWeekType={'AllocForecast'}>}aggr(max(distinct AFAllocation), (Key1,OrderKey)))

There are other measures in the table that are ok to be affected by the 'Forwarder' filter. just this one measure needs to ignore selection. Tried the following but not returning the required result:

Sum({Forwarder}{$<AFWeekType={'AllocForecast'}>}aggr(max(distinct AFAllocation), (Key1,OrderKey)))

 

Appreciate your help please

Labels (5)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

Perhaps, like this.

Sum(DISTINCT{<Forwarder=>}Aggr(Max({$<AFWeekType={'AllocForecast'},Forwarder=>} AFAllocation), Key1, OrderKey))

View solution in original post

3 Replies
sujana1621
Contributor III
Contributor III

Hi,

Can you try this...

Sum({$<Forwarder=,AFWeekType={'AllocForecast'}>}aggr(max(distinct AFAllocation), (Key1,OrderKey)))

 

BrunPierre
Partner - Master
Partner - Master

Perhaps, like this.

Sum(DISTINCT{<Forwarder=>}Aggr(Max({$<AFWeekType={'AllocForecast'},Forwarder=>} AFAllocation), Key1, OrderKey))

G3S
Creator III
Creator III
Author

That worked. thank you. 
I had to remove the distinct to show the correct numbers.