Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Chart with aggr function not consistent

Hello,

I have a graph with dimension FECHA_GARAN_BAJA and the following expression: sum(aggr(sum(<TIPO_BAJA={HIPO}>}DISTINCT VALORACT_BAJA, NUMBIEN_BAJA))

The problem is that whenever there is no filter added, it shows the following:

Captura.PNGHowever, if I click on the day 17/10/2019 and this filter is applied

Captura3.PNG

the graph changes to show another different result:

Captura2.PNGThis second result is the one I'm looking for and the right outcome of the operation. This happens not just for that day but for all the dates.

My question is: how can the graph show two different results for the same day if I'm just clicking on it and filtering by its own dimension (FECHA_GARAN_BAJA)? How can I get it to show the right results even when I'm not applying the filter?

1 Reply
Highlighted
Digital Support
Digital Support

Re: Chart with aggr function not consistent

Alex, I am definitely no guru on this one, but here is a Design Blog post that I think may potentially help explain things a bit further:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

The other thing I did just notice though, you seem to be missing a left { in the expression you posted, just FYI, not sure how things should be working if you do not have it correct in your actual expression...  Sorry I do not have anything better for you.  May need to attach the QVW on this one too in order for folks to be able to see the data model etc. too in order to try to figure out why things are not consistent for you.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.