Discussion Board for collaboration related to QlikView App Development.
i ned your help, for get the korrekt formul in a diagram.
There are more departments, with each more people, and I would like to see only the oldest and the secound oldest each department. And that in a table like this:
There are more People: (which not shown in the Table):
I tried to show the first Table, with the Formul:
But it doesn't work.
Respectively the table above I get over the constraint condition, I actually want the table to look like this:
I found a formula, but it work not correkt:
=Aggr(if(rank( sum(Age) ) =1, Person &' ('&( sum(Age)) &')'), Depatrment, Age)
because if there are two Age for the first Place, it show nothing from them.
Who have an idea, to show some like that: