Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

Pivot table vs Aggr() function issue

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

3 Replies
Highlighted

Re: Pivot table vs Aggr() function issue

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

Highlighted
Partner
Partner

Re: Pivot table vs Aggr() function issue

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

Highlighted

Re: Pivot table vs Aggr() function issue

Would it be possible to share your qvf file?