Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ramusubramani
New Contributor II

Update value for Blank cells

Hi

I have table as below and would like update blank cells in B to 0 (zero) for row 2,5,6.

TabA: 

AB
1100
2
3300
4400
5
6
7700

But i know the below script to replace value.  is there any other ways to replace value for table without full resident load again especially with joins or something in script

TabB:

A,

If(len(B)=0,0,B) as B

resident TabA;

regards

Ramu

Tags (1)
6 Replies
briancopple
Contributor II

Re: Update value for Blank cells

Hi

Why not do your check If(len(B)=0,0,B) as B in the initial load then you won't need to do a resident load.

beck_bakytbek
Valued Contributor III

Re: Update value for Blank cells

Hi Ramu,

you can use in this case: IsNull-Function or as @Brian Copple said, you can use if(len(B)=0,0,B) without resident load

ramusubramani
New Contributor II

Re: Update value for Blank cells

I am getting above table result after did some joins There is any other way to do that

briancopple
Contributor II

Re: Update value for Blank cells

Hi Ramu

It may help if you can share your app or some more info to your requirements. Are you joining columns A & B in your example from different tables? If so you should still be able to test for blanks in your column B in the initial load. Maybe I'm not understanding your problem correctly.

vishsaggi
Esteemed Contributor III

Re: Update value for Blank cells

Can you show us those Join script you have that is populating this result table?

johncaqc
Valued Contributor

Re: Update value for Blank cells

Hi Ramu,

In  a table box that isn't possible, but in a straight table it is. You need a way to write the expression and table box doesn't include that. In a straight table use A as dimension and then your expression as expression. On Presentation tab uncheck Suppress Zero-Values.

HTH,

John

Community Browser