topic Re: Ignore Field selection in set analysis where null values are associated in QlikView

Ignore Field selection in set analysis where null values are associated

Tue, 05 May 2015 17:09:07 GMT

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

Re: Ignore Field selection in set analysis where null values are associated

Tue, 05 May 2015 17:15:22 GMT

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.

Re: Ignore Field selection in set analysis where null values are associated

Gysbert_Wassenaar — Tue, 05 May 2015 17:18:23 GMT

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

Re: Ignore Field selection in set analysis where null values are associated

ramoncova06 — Tue, 05 May 2015 17:22:01 GMT

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

Re: Ignore Field selection in set analysis where null values are associated

Tue, 05 May 2015 17:23:03 GMT

Nope, @Gysbert Wassenaar

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

Re: Ignore Field selection in set analysis where null values are associated

Tue, 05 May 2015 17:26:47 GMT

It comes out to be value '0'

@RamonCova06

Re: Ignore Field selection in set analysis where null values are associated

Tue, 05 May 2015 17:28:57 GMT

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.

Re: Ignore Field selection in set analysis where null values are associated

Thu, 07 May 2015 15:20:27 GMT

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))