Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RKULKARNI4
Contributor III
Contributor III

column display as ---

Hello Team,

For one of the column(ColA) I need to display as '---' if it is  "blank" or '-'  

If (trim(ColA)='-' or trim(ColA)='--' or trim(ColA)='.' or trim(ColA)='','---',ColA) as "ColA"

After applying this formula still it is displaying in the column as '-'.Please advise how it can be sorted it out.

Thanks in advance

Regards

RK

 

 

 

1 Reply
sunny_talwar

Is it possible that you have Null in there? Try this

If(Len(Trim(ColA)) = 0 or Trim(ColA) = '-' or Trim(ColA) = '--' or Trim(ColA) = '.' or Trim(ColA) = '', '---', ColA) as "ColA"