Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
aminehaddar
Not applicable

problem with aggregation

Hello,

I have this table:

Agence, SEGMENT, SOUS_SEGMENT as dimensions.

The aim of this, is to got an aggr by agence, to have the measure 'poids'=100% for every agence,

or when I don't use filters like the first picture, I got wrong % ,

or when I select one agence, like the second picture, I got the right numbers.

 

My question: what to change to get the numbers like the second picture for every agence.

I used: 

sum(ENCOURS_PLACEMENT_HIST) for encours_placement_hist

aggr(sum(ENCOURS_PLACEMENT),AGENCE,SEGMENT,SOUS_SEGMENT)
/
aggr(sum(total ENCOURS_PLACEMENT),AGENCE,SEGMENT,SOUS_SEGMENT)   for 'poids'

 

So, I need to correct the poids column and for each agence, I got 100% as total

 

1.PNG

2.PNG

Labels (2)
1 Reply
parthesh
Not applicable

Re: problem with aggregation

can you provide QVW with sample data?