Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

complex AVG IF or aggr

Hi all,

My table is like that and

I want to calculate the average of Tx de marge but

     I Don't want to take the value marge if date fin contrat <31/08/2018 and if Matricule facturation = INTERNE

     I want to take all the value marge if  Début de contrat <31/08/208

Capture qlik 3.JPG

1 Reply
New Contributor II

Re: complex AVG IF or aggr

Nobody to help me ? :-(