Discussion Board for collaboration related to QlikView App Development.
I need your help.
I am having a table which looks like this
but I would like to the it in this way
but also dynamically, so if I select Treaty 1 and 2 I want to see 1,2
also I do not want to use distinct, because bookings can have the same amounts for 1 Treaty
Any Ideas on that?
Solved! Go to Solution.
I don't know what makes the unique combination where the duplication is present at? May be add them all as dimensions like this
Sum(Aggr(Amount, Loss, GenReUnderwritingYear, DimensionX, DimensionY...))