Discussion Board for collaboration related to QlikView App Development.
Let's assume I have a table with a simple structure:
I would like to ORDER the records by Value (ascending) and then SPLIT the records in 10 sets, each set HAVING THE SAME sum(Value) - that is sum(TOTAL Value)/10.
The end result would be a chart showing all those 10 sets and the number of records contained in each set. Something like this:
Could anyone please suggest a solution for this?
I am not understanding how you want to split in 10 sets.
I am thinking that you would first
Load your initial table T1,
Reload it using a resident load order by value asc;
Then flag similar record to create your 10 theoretical subsets.
I think you can use the Aggr(rank(Expression),RecordId) function and use the rank as dimension with a count of RecordID...
Hope the attachment might helps.
I have used inline load. You can generate this using rowno or recno.
See attached example.