Need help in showing alphanumeric column in straight table

[praveensprabhu]

Hi All,

Need urgent help in resolving this issue.

I have column that has  both numeric and text values as shown below - 

ATS
47711
55639
BFNLD
17OV1
56057
55937
55933
CARB1
55582
55717

When i use this column as dimension in straight table, all values appear.

But when I  change it  to calculated field, the alphanumeric/text values do not appear.

Can somebody help me to sort this out.?

The expression for calculated field is 

=if(isnull(program),'zOthers',if(isnull(ats) and isnull(Qlik) ,'zOthers',ats))

What I am trying to do is, I want to show only few ATS values, rest of them has to be grouped as Others.

Now when i am using this formula, all the text values of ATS column are showing blank. numbers are appearing.

Someone pls help asap.

[Brett_Bleess]

I would recommend reviewing the Help as a first step, as that seems to have some key points in it that may be helpful to you:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/NULLF...

The following Design Blog post may be helpful as well:

https://community.qlik.com/t5/Qlik-Design-Blog/On-Boolean-Fields-and-Functions/ba-p/1462815

If you want to search further in that area, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett