3 Replies Latest reply: Jun 13, 2017 9:07 PM by Sunny Talwar RSS

    Pivot table vs Aggr() function issue

    Sebastian Manar

      Hi experts,

       

      I´m having a problem with a pivot table and an expression that uses an aggregation function.

      Screenshot_1.png

      The first expression (second column) shows the correct value but i had to use an aggr(), the second expression (third column) shows an incorrect value because QlikSense but dont uses an aggregate.

       

      i could define my aggr function with certain dimensions, the problem is when the final user change the order of the dimensions...that crashes with the order of the dimensions in the aggr on the expression.

       

      How can i fix this??

      Why QlikSense do the count over the total and not discrimate for each value dimension?? (Because third column)

       

      Hope you can help me