Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

To handle null and N/A and 0 and special characters

Policy

Issue AgentProducer
111120123
111001@Null
112190'0

Hi friends,do needful from you .have table with some columns while loading into qlik need to check constrains

Policy column should not have any repeated values uniquely ,Issue Agent column not to have ascii or special char and producer not to have null values.above source  are not to load into qlik showing as error msg

2 Replies
Employee
Employee

Re: To handle null and N/A and 0 and special characters

Below see the WHERE clause for all filters. You can keep only the characters you want in keepchar() . Wasn't sure if letters and numbers were ok or just numbers.

also for true nulls, you will need to use  'not isnull(Producer)'  rather than Producer='NULL'

-------------------------------

LOAD

  Distinct

  Policy,

     [Issue Agent],

     Producer

FROM

[http://community.qlik.com/thread/138828]

(html, codepage is 1252, embedded labels, table is @1)

where

  (

  len( upper( [Issue Agent])) = len( keepchar( upper([Issue Agent]),'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'))

  and

  Producer<>'0'

  and

  Producer<>'NULL'

  )

;

Not applicable

Re: To handle null and N/A and 0 and special characters

Thanx for your solution but problem is while loading data into qlik to display error messages with particular column has null values

Community Browser