Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Avg If or AGGR

Hi all,

My table is like that and

I want to calculate the average of Tx de marge


but


I want all the value if [début de contrat] <31/08/2018


and


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

Thanks for your help

Capture qlik 3.JPG

0 Replies