Discussion Board for collaboration related to QlikView App Development.
I need help, I have this por expression Double,
and this por Triple
I have this natural table:
But I need to separete de data of the Amount, for example, Sum Value F is 10, so for doubles is 9 and for Triples 1,
the maximum for Doubles is 9, and Triples don´t have limits,
The total results are this
And Amount in Doubles and Triples need to be this
But the total sum not is true, Doubles=44 and Triples=4, I don´t Found the solution, and subsequently, I will to do a chart whit the velocimeter, Thanks a lot.
Suggest to slightly simplify the expressions
=Sum(Aggr(RangeMin(9, Sum(Amount)), Group))
=Sum(Aggr(RangeMax(0, Sum(Amount)-9), Group))
View solution in original post
Thanks a lot, its working, and very simple.
Thanks a lot, its work, too.