topic Re: new feild with null values in QlikView

new feild with null values

Anonymous — Wed, 26 Dec 2012 13:24:42 GMT

hi,

i build new feild in the script with an existing feild.

but in some cases the feild is null.

how i need to write it in the script ?

this is what i wrote :

if(Match([agent],500,504,509,506,505,503,502,508,null),'בנייה',
if(Match([agent],507),'תעשייה',
if(Match([agent],510),'ייצוא'))) as [תאור קוד סוכן - דוח 5]

thanks'

yarin.

Re: new feild with null values

swuehl — Wed, 26 Dec 2012 13:59:22 GMT

Try like this:

if(Match([agent],500,504,509,506,505,503,502,508) or len(trim([agent]))=0,'בנייה',
if(Match([agent],507),'תעשייה',
if(Match([agent],510),'ייצוא'))) as [תאור קוד סוכן - דוח 5]

Re: new feild with null values

Anonymous — Thu, 27 Dec 2012 04:28:21 GMT

hi,

it doesn't work.

now i get 2 gruops the all feild together , and the null feild alone.

i need the the nuul feild will be with the first gruop.

do you have any idea ?

Re: new feild with null values

Thu, 27 Dec 2012 05:28:35 GMT

Hi,

Is 'NULL' value you have in Agent field or it like empty cell..?

If you have empty cells under Agent field insted of putting 'null' do like this ' ' else if you have value null put like this 'null'

hope it helps!!..

Re: new feild with null values

Anonymous — Thu, 27 Dec 2012 07:13:22 GMT

hi. still doesn't work.

Re: new feild with null values

swuehl — Thu, 27 Dec 2012 15:25:52 GMT

Seems to work ok for me (just using an empty agent value for demonstration instead of a NULL, but len(trim(agent)) should handle both):

LOAD *,

if(Match([agent],500,504,509,506,505,503,502,508)or len(trim(agent))=0,'בנייה',

if(Match([agent],507),'תעשייה',

if(Match([agent],510),'ייצוא'))) as [תאור קוד סוכן - דוח 5]

INLINE [

agent, field

500,1

504,2

509,4

507,5

508,6

510,7

]