May be this
LOAD TypeOfAccount, Description, TotIncome,SubField(PurgeChar(BankNumber,'B'),';') as BankNumber Inline [
Summary,Sum of All,50000,B1000-3000;B3000-3500
NoConcatenate LOAD TypeOfAccount, Description, TotIncome,
SubField(BankNumber,'-',1)+IterNo()-1 as BankNumber
While SubField(BankNumber,'-',1)+IterNo()-1 <= SubField(BankNumber,'-',2);
Drop Table Temp;
Thanks for replying Antonio
From your teachings,I learned abit about using functions in the same table. And how the IterNo()-1 and While works.
And I see my version of Qlikview (PE) can only handle a maximum amount of numbers..
Meaning, removing one 0 from each value .. 1000 becomes 100, 3000 becomes 300, 3500 becomes 350 etc.
Then all values are showing.
Thanks for the solution