Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tahreen371
Contributor III
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
gn_marvs1989
Contributor III
Contributor III

Try:

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

tahreen371
Contributor III
Contributor III
Author

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

gn_marvs1989
Contributor III
Contributor III

Can you provide us the app with data?