topic Re: change field values in QlikView

change field values

Tue, 29 Apr 2014 05:17:44 GMT

I have 2 tables . One to many.

table A has field CUS_REF_ID, and table B has CUS_REF_ID and CUS_REF_NAME.

many values in table A has no values in table B. so the CUS_REF_ID is null.

When displaying table A as a chart choosing CUS_REF_NAME, the values in table A which is null CUS_REF_ID appears as "-".

Can I change this value to something readable not "-".

Re: change field values

NareshGuntur — Tue, 29 Apr 2014 05:30:12 GMT

Hi Ayman,

Go to Properties ---> Presentation tab

Left side bottom, you have an option to replace the null value with value you wish.

Cheers,

Naresh

Re: change field values

Tue, 29 Apr 2014 05:35:27 GMT

In script you can give like this

load

CUS_REF_NAME,

if(CUS_REF_NAME<>'' and CUS_REF_ID='' ,'Novalue',CUS_REF_ID) as CUS_REF_ID

from[]

Hope it will help.....

Re: change field values

Tue, 29 Apr 2014 05:40:15 GMT

I can't find it.

I have only option Omit Rows where Field is NULL.

but no option to change the value

Re: change field values

mdmukramali — Tue, 29 Apr 2014 05:44:03 GMT

Dear ,

kindly find the attached.

I hope it will help you.

Thanks,

Mukram.

Re: change field values

Tue, 29 Apr 2014 05:53:07 GMT

Sorry but I think I need to explain more about the relation between the table.

Table A

Field: A_DB_ID.

Table B.

A_DB_ID

NAME_DB_ID

Table C

NAME_DB_ID

NAME.

so the relation is

select A.A_DB_ID, C_.NAME from A,

(select NAME,A_DB_ID from B,C where B.NAME_DB_ID = C.NAME_DB_ID) C_

where A.A_DB_ID = C_.A_DB_ID.

Re: change field values

Tue, 29 Apr 2014 05:59:33 GMT

I am able to in Straight table, but I need to change the NULL values in the CHARTS

Re: Re: change field values

mdmukramali — Tue, 29 Apr 2014 06:06:33 GMT

Dear ,

kindly find the attached file.

Re: change field values

MK_QSL — Tue, 29 Apr 2014 06:11:53 GMT

Dear Ayman,

If CUS_REF_ID don't have data in your Fact/Main/Transaction Table and if you want to load only those CUS_REF_ID having some data, you can use as below

1) First Load your Main or Fact or Transaction Table

[MAIN TALE]:

LOAD

CUST_REF_ID,

Field2,

Field3.....

From TableName;

2) Now Load your CUS_REF_ID Table

CUSTOMER:

LOAD

CUS_REF_ID,

CUS_REF_NAME

From TableName

Where Exists (CUS_REF_ID);

This will restrict CUS_REF_NAME having no records in main table to load

Hope this helps..

Re: change field values

Tue, 29 Apr 2014 06:49:51 GMT

Thankx Manish,

But I need these values. I just want to change the null value something like.

"Unregistered Customer"

Re: change field values

jagan — Tue, 29 Apr 2014 06:55:34 GMT

Hi,

Try like this

CUSTOMER:

MAPPING LOAD

CUS_REF_ID,

CUS_REF_NAME

From TableName

Where Exists (CUS_REF_ID);

[MAIN TALE]:

LOAD

CUS_REF_ID,

ApplyMap('CUSTOMER',CUS_REF_ID, 'Unregistered Customer') AS CUS_REF_NAME,

Field2,

Field3.....

From TableName;

Hope this helps you.

Regards,

Jagan.

Re: change field values

SunilChauhan — Tue, 29 Apr 2014 07:03:12 GMT

see the attched file

please write "Unresgister Customer" in place of - in attched screen

i.e Chart properties-> presentation ->null smbol-> Unregister Customer

...........................................Missing Symbol---->Unregister Customer