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: 
praveensprabhu
Contributor
Contributor

Need help in showing alphanumeric column in straight table

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.

Labels (2)
1 Reply
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.