Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

stanley123
New Contributor

How to check if the fields from excel is '#N/A'?

Does anyone knows how to check if the fields in a column is '#N/A'? i have tried some methods such as:

if(not(left("ColumnName",1) = Chr(35)

if(not(SubField("ColumnName",'N',1) = Chr(35)

but nothing seems to work and i'm not sure why. It would only work if i find and replace every fields that are '#N/A' to '#NA' in the excel sheet

1 Reply
MVP
MVP

Re: How to check if the fields from excel is '#N/A'?

I have advised someone else on the topic in this thread: Help with reading Excel #Ref

Even though the title of the thread only refers to #REF it also includes #N/A values in the suggested solution.