Adding numbers to an scheme account.

marcel_olmo — Thu, 16 Sep 2010 12:24:30 GMT

Hi guys,

I got stuck in one scheme account's problem. Maybe someone could know easily how to do the following:

I have the following table with the number of the scheme account, the number of the account, and a flag which indicates if the account number has the maximum digits (in this case 7, but is completely dynamic).

I want to create another table with the number of accounts which hasn't the max_length, and I want to add to them as many '0' (for minimum value) and as many '9' (for maximum value) as it would be necessary.

I did it in a static way :

Cuentas_Mayor5 :

load distinct

N_Fila as N_Fila2,

N_Fila_Cuenta&'0000' as N_Fila_Cuenta_Min,

N_Fila_Cuenta&'9999' as N_Fila_Cuenta_Max

resident Cuentas_Mayor4 where (Max_Length_Cuenta = 0);

And I got the desired result in the following table :

I have in a variable the value of the maxLength. The point to do this is easy, it's just add as many '0' as the result of maxLength - len(currentCount), but I don't know how to do it in Qlikview.

Any help would be appreciated.

Thank you.

Cheers!!

Adding numbers to an scheme account.

Thu, 16 Sep 2010 15:47:18 GMT

Hi,

Here you are a possible solution.

I hope it helps you.

Regards.

Adding numbers to an scheme account.

marcel_olmo — Thu, 16 Sep 2010 15:56:29 GMT

Muchas Gracias Miguel.

It was exactly what I was looking for : the function repeat ('something', 'n-times').

Very easy if you know exacty which function fits on your problem.

Thank you very much.

See you around!

topic Adding numbers to an scheme account. in QlikView

Adding numbers to an scheme account.

Adding numbers to an scheme account.

Adding numbers to an scheme account.