Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

how to fill blank value in qlikview..

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

];

1 Reply
tresesco
Not applicable

Re: how to fill blank value in qlikview..

try:

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

PFA