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.

[#2]

May be use a "if clause" in expression helps, for example =if("field1"=-1,"yes","no")

change the label in expression tab to the original one. Hope it helps!

[Anonymous]

qlikview defines true as -1

so if you define an Expression 0=1 you will get 0,m if you define 1=1 as Expression you will get -1

[#4]

M not using any expression guyzz, just simply i want fields value in straight table.

in table m using aggr function for some other dimension and that is  not related to that dimension.

[#5]

Sorry, I am not sure with your situation, but for me expression is just like a field in straight table. Moreover, can you try to use calculate dimension to solve this problem? Hope it helps!

[PrashantSangle]

Hi,

take that field in list box. What value you get in that list box??

Can you post screen shot of it List box as well as Straight table.

Regards

[#7]

In list box its showin -1 oly but in DB its yes.

[juleshartley]

That sounds like you're getting a 'true / false' field for a database or similar.

You'll need to convert that into text or dual in the load script.

[#9]

Yes it is true/false field.

[Anonymous]

Read on this discussion

On Boolean Fields and Functions