Not Getting corrct field value

[#1]

Hiiii,

I m creating the straight table where i have some dimensions, i have one dimension within that i have some values yes or no.

but m not getting the yes or no value m getting -1 in the place of yes.

help

Thanks & Regards,

Qlicker.

[susovan]

Hi Abhishek,

You also try this in your script,

Table:

LOAD * INLINE [

Field

0

1

];

LOAD*,

if(Field=0,'Yes','No') as Field1 Resident Table

[#3]

But dear i have already table in my DB and values as well, in database its showing yes as a value but wen m uploading to QV its showin -1 in listbox.

[Kushal_Chawda]

How that dimension is calculated in script

[#5]

M not calculating any dimension here, juzz fetchin the data from the DB.

[ramasaisaksoft]

Hi Abhi,

You are saying it is a Dimension data,So if you create a list box had you got the correct result ?

if No then check your data(List box data also not showing Properly)

If Yes (List box data showing Properly)then ,Verify may be you are calling calculated Dimension? your calculation is modifying your values

else go to number format and Check it.