Forum Discussion

jcampbell474's avatar
jcampbell474
Helper IV
6 years ago
Solved

Is this an aggregation issue?

I've been encountering an issue with overall matrix averages not matching card averages.  In Qlikview, it was an aggregation issue...that was relatively simple to fix using this syntax: avg(aggr(sum(Total <UserId,cReportGroup,FiscalYearMonth> SalaryxMin),UserId,cReportGroup,FiscalYearMonth)) Total ignored the dimension(s) and manual aggregation was achieved at the end of the expression.  

 

Measure = Averagex(CRM_SalesRep,SUM(GMQuote[Actual Quotes]) / SUM(CRM_SalesRep[Total Calls]))

 

Can anyone help me understand what it happening, why the two results are different?

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi jcampbell474 

    As tested, the card show the total of the matrix.

    Measure = AVERAGEX(Table1,SUM(Table2[value2])/SUM(Table1[value1]))

    If you have different scenario, please show me screenshots and your expected result.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi jcampbell474 

    As tested, the card show the total of the matrix.

    Measure = AVERAGEX(Table1,SUM(Table2[value2])/SUM(Table1[value1]))

    If you have different scenario, please show me screenshots and your expected result.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.