Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Need urgent help for this script

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

    >}

[Fact. Mt MO]
+ [Fact. Mt D]
+ [Fact. Mt RF]
+ [Fact. Mt FV]
+ [Fact. Mt FA]
+ [Fact. Mt FD]
+ [Fact. Mt A]

)

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

2 Replies
MVP
MVP

Re: Need urgent help for this script

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

roharoha
Valued Contributor III

Re: Need urgent help for this script

NULL handling in QlikView

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

Community Browser