Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Not applicable

Can someone help me ???

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 ?

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: Can someone help me ???

You cannot have evaluations on the Left side of the Equal sign, you probably need to create a new field that totals all of these fields which you can refer in set analysis

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]

)

3 Replies

Re: Can someone help me ???

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

When you say not working, what is the issue? Error? Incorrect result? Something else? Can you share what it should do and what it is doing for you?

vinieme12
Esteemed Contributor II

Re: Can someone help me ???

You cannot have evaluations on the Left side of the Equal sign, you probably need to create a new field that totals all of these fields which you can refer in set analysis

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]

)

Not applicable

Re: Can someone help me ???

you're right. I tried to create a new field named "Fact. Mt Total" which is the sum of the others and that worked.

Thank you.

Community Browser