Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
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