Ignore Field selection in set analysis where null values are associated

[#1]

Below is the table where i am calculating the sum of Dim1 and trying to ignore the selection Filter and alll the values that are associated are nulls(-), how to ignore the filter selection when i am calculating the dim1 sum or count?

Filter	Dim1
Solicited
	0
	0.5
	0.666666667
	0.833333333
	1
	1.166666667
	1.25
	1.666666667
	2
	2.5
	2.666666667
	4
	4.666666667
	5
	6.666666667
	10

[#2]

I have tried

Sum(aggr(sum({<filter={'*'},field2=,field3=>}dim1),fieldA,FieldB))

Sum(aggr(sum({<filter={'*'}-{''},field2=,field3=>}dim1),fieldA,FieldB))

Sum(aggr(sum({-<filter={'*'}>*<field2=,field3=>}dim1),fieldA,FieldB))

not sure if  i am missing anything i just want to ignore the filter slections in the calculation.

[Gysbert_Wassenaar]

Maybe like this: sum({<[Filter Solicited]=,Dim1={'*'}>}Dim1)

[ramoncova06]

you can try with nullcount

=Sum({<dim1={"=nullcount(filter)=0"},field2=,field3=>}dim1)

here is  a post from HIC on how to handle nulls

NULL handling in QlikView

[#5]

Nope, @Gysbert Wassenaar

still doesn't work. The numbers does change with filter selection.

[#6]

It comes out to be value '0'

@RamonCova06

[#7]

Well i have another fields as well in the set analysis where some of there to be ignored and some to set the values and also the expression has aggr as well does with all these parameters the soultions provided may not be working but again im anticipating this might be the reason i guess.

[#8 · Accepted solution]

This is what solved my issues

AS i was using set analysis inside a aggr and sum. i did another set ignore condition on the sum as well

here what worked form me

Sum({<Filter=>}aggr(sum({<Filter=,field2=,field3=>}Dim1),Dim2))