topic Re: Need urgent help for this script in QlikView

Need urgent help for this script

Wed, 26 Apr 2017 09:37:06 GMT

Avg({$<	[Type Facture]={'Avoir'},
	([Fact. Mt MO]
	+ [Fact. Mt D]
	+ [Fact. Mt RF]
	+ [Fact. Mt FV]
	+ [Fact. Mt FA]
	+ [Fact. Mt FD]
	+ [Fact. Mt A]
	) = {">=$(=vMt_FT_Min) <=$(=vMt_FT_Max) >=$(=vMt_FT_Max_1) <=$(=vMt_FT_Min_1)"}

)

This instruction is not working. Can someone urgently help me ?

swuehl — Wed, 26 Apr 2017 16:13:20 GMT

Create a new field in your load script with the sum of

LOAD

Rangesum([Fact. Mt MO], [Fact. Mt D], [Fact. Mt RF], [Fact. Mt FV], [Fact. Mt FA], [Fact. Mt FD], [Fact. Mt A]) as FactSum,

...

Then use this field in your set expression

Avg({$<	[Type Facture]={'Avoir'},
	FactSum = {">=$(=vMt_FT_Min) <=$(=vMt_FT_Max) >=$(=vMt_FT_Max_1) <=$(=vMt_FT_Min_1)"}

FactSum

)

edit: and I think your numeric search should only contain one range (only once >= and <=):

">=$(=vMt_FT_Min) <=$(=vMt_FT_Max) >=$(=vMt_FT_Max_1) <=$(=vMt_FT_Min_1)"

Not sure what you want to do here, but I believe the current search will not work as intended

Anonymous — Wed, 26 Apr 2017 16:15:34 GMT

null()+x = null() ...