Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

try:

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

PFA