Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cmorri1988
Contributor

Aggr Issue

Hi There,

Does anyone have a solution for the attached image please?

Within my table, I want to show BINDING totals from selections where GENRE is the same as the record within the table.

The image should hopefully explain best.

Thank you!

small test application also attached should it help.

Tags (1)
4 Replies
MVP
MVP

Re: Aggr Issue

Are you looking at the min ISBN per genre?

Maybe

=Sum( Aggr( FirstSortedValue( BINDING, ISBN), GENRE))

cmorri1988
Contributor

Re: Aggr Issue

Thanks Stefan,

Not necessarily the minimum as selection could be any ISBN per Genre.

Can see why my example would make you think that!

Thanks,

Carmelle

MVP
MVP

Re: Aggr Issue

Sum(TOTAL<GENRE> Aggr( BINDING, GENRE))

?

cmorri1988
Contributor

Re: Aggr Issue

Perfect, worked wonders!!!

Much appreciated!!