how to fill blank value in qlikview..

[#1]

Dear All

load * inline

[

qty

1

-

5

-

-

-

10

-

-

-

15

-

];

fill blank value with above value

means it will show as

load * inline

[

qty

1

1

5

5

5

5

10

10

10

10

15

15

];

[tresesco]

try:

If(Isnull(qty) or qty='-', peek('NewQty'),qty) as NewQty

PFA