Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
small test application also attached should it help.
Are you looking at the min ISBN per genre?
=Sum( Aggr( FirstSortedValue( BINDING, ISBN), GENRE))
Not necessarily the minimum as selection could be any ISBN per Genre.
Can see why my example would make you think that!
Sum(TOTAL<GENRE> Aggr( BINDING, GENRE))
Perfect, worked wonders!!!