# 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
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
MVP

## 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?

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.