Need help in showing alphanumeric column in straight table

praveensprabhu — Sat, 16 Nov 2024 00:56:43 GMT

Hi All,

Need urgent help in resolving this issue.

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

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.

Re: Need help in showing alphanumeric column in straight table

Brett_Bleess — Wed, 22 Apr 2020 20:32:19 GMT

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:

The following Design Blog post may be helpful as well:

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

Regards,
Brett