topic How is SAP unassigned i.e. # data read by QV? in QlikView

How is SAP unassigned i.e. # data read by QV?

avastani — Fri, 19 Jun 2009 02:20:29 GMT

I have lots of data in a field that is unassigned i.e. not blank, not null. SAP infuses # for it. how is it recognized in QV because it does not see #.

I tried '' (blank i.e. empty string) IsNULL and none worked.

Any ideas? Thanks.

How is SAP unassigned i.e. # data read by QV?

Fri, 19 Jun 2009 02:56:19 GMT

I had the same issue with some data unassigned.

Here's what I did....Chart Properties...Presentation Tab and change the Null & Missing Symbol to let say 'NA'.

Regards

Eraaj

How is SAP unassigned i.e. # data read by QV?

avastani — Fri, 19 Jun 2009 03:10:57 GMT

That is at runtime level. how about at design time in the script?

do i ask for NA as well?

How is SAP unassigned i.e. # data read by QV?

Fri, 19 Jun 2009 04:12:32 GMT

"NullAsValue" statement can be applied @ scripting time.

Regards

Eraaj

How is SAP unassigned i.e. # data read by QV?

avastani — Fri, 19 Jun 2009 06:13:17 GMT

so you mean to say LOAD IF(someField = 'NullAsValue', 1, 0) AS myField FROM some.qvd; will do the trick? I doubt because that makes it a string, doesn't it?

Amir.

How is SAP unassigned i.e. # data read by QV?

Fri, 19 Jun 2009 19:25:30 GMT

Hi Amir,

I believe you should not use NullasValue in if statement . It should be as below and this statement should be below the set statements.

set NullValue='<NULL>';

NullasValue Fieldname1,Fieldname2;

- Sridhar