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: 
prma7799
Master III
Master III

If else condition

Hi All,

I have table like below

ColA  ColB ColC ColD

1        0          0     0

0        1          0     0    

0        0          1     0    

0        0          0     1

and I want output like   

ColA  ColB ColC ColD

1                        

         1                     

                    1          

                          1

How to achieve it?

Thanks

PM

2 Replies
anbu1984
Master III
Master III

Do you want replace Zeros by Nulls?

Load If(ColA<>0,ColA) As ColA, ... From Table

NareshGuntur
Partner - Specialist
Partner - Specialist

Try this

LOAD Replace(A,0,'') as A,

Replace(B,0,'') as B,

Replace(C,0,'') as C,

Replace(D,0,'') as D

from XXX;

Cheers,

Naresh