Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tahreen371
New Contributor III

How to remove the hiphen value and get blank space in straight table?

Hello All,

When i apply this condition -- =if(len(Business_Partner)='0',' ',Business_Partner) to Column Business_Partner it works and gives me blank spaces with the colour code but when applied to P_Name or User_Name Column it fails and also tried with the below conditions as well and still No help.

=if(len(trim(User_Name))<>0,User_Name,'NA')

//=if( User_Name = 0,1,if(ISNULL(User_Name) OR LEN(User_Name)=0,1,User_Name))

//=if(isnull(User_Name),'0',User_Name)
//=If(Len(Trim(User_Name))='0',' ', User_Name)

Can anyone Plz assist on this? Plz refer the Screenshot.

 

Thanks & Regards

 

3 Replies
Highlighted
gn_marvs1989
New Contributor III

Re: How to remove the hiphen value and get blank space in straight table?

Try:

=alt(Trim(User_Name),'NA')

tahreen371
New Contributor III

Re: How to remove the hiphen value and get blank space in straight table?

No that doesn't help...its still the same

gn_marvs1989
New Contributor III

Re: How to remove the hiphen value and get blank space in straight table?

Can you provide us the app with data?