Sum Null

[pgalvezt]

Hi, I don't know if QlikView can do this. But What I want is take all values to the first row in INP. Should be just all together

Inp                 -

9662927957    -

-                    -

-                    -

-                    -

-                    -

-                    -

-                    -

Total

9662927957   -

So after that I can delete nulls.

Thanks

[whiteline]

So you cann't attach the whole file, please paste dimension formulas that you use now.

[pgalvezt]

For Tramos

=

if(Comercio='Inp', 'Tramo 0', Tramos)

For Comercio

=

if(isnull(Comercio), 'Inp', Comercio)

[whiteline · Accepted solution]

For Tramos you shoud use:

=if(Comercio='Inp' or isnull(Comercio), 'Tramo 0', Tramos)

Because all null Comercio also replaced with 'Inp'.