Pivot table vs Aggr() function issue

[slondono]

Hi experts,

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

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

[sunny_talwar]

Are you using single quotes around your set analysis search string? Try double quotes

[slondono]

no, is exactly the same. I have been trying diferent ways to calculate this indicator without using Aggr() function but its not working

[sunny_talwar]

Would it be possible to share your qvf file?