This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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: