# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Not applicable

## mapping problem zero values

I have a problem with mapping. In my database I have an optionfield with 4 values: 0,1,2 and 3. I am using mapping to give a description:

PostingType_map:

0,Purchase,

1,Sale,

2,Consumption,

3,Output
]
;

The conversion works for 1,2 and 3 but not for 0. The zero stays zero. Any ideas?

Tags (2)
1 Solution

Accepted Solutions
Esteemed Contributor

## Re: mapping problem zero values

Please use some field name because first row in inline is considered as column Name

PostingType_map:

ID,Name//<---------------------------------for example
0,Purchase,

1,Sale,

2,Consumption,

3,Output
]
;

hope this helps

Esteemed Contributor

## Re: mapping problem zero values

Please use some field name because first row in inline is considered as column Name

PostingType_map:

ID,Name//<---------------------------------for example
0,Purchase,

1,Sale,

2,Consumption,

3,Output
]
;

hope this helps

Community Browser