topic Re: Update value for Blank cells in QlikView

Update value for Blank cells

Anonymous — Thu, 18 Aug 2016 13:48:16 GMT

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

TabA:

A	B
1	100
2
3	300
4	400
5
6
7	700

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:

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

resident TabA;

regards

Ramu

Re: Update value for Blank cells

Anonymous — Thu, 18 Aug 2016 13:55:45 GMT

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.

Re: Update value for Blank cells

beck_bakytbek — Thu, 18 Aug 2016 13:57:59 GMT

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

Re: Update value for Blank cells

Anonymous — Thu, 18 Aug 2016 13:58:45 GMT

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

Re: Update value for Blank cells

Anonymous — Thu, 18 Aug 2016 14:02:04 GMT

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.

Re: Update value for Blank cells

vishsaggi — Thu, 18 Aug 2016 14:02:23 GMT

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

Re: Update value for Blank cells

johnca — Thu, 18 Aug 2016 14:04:56 GMT

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