topic Re: Not Getting corrct field value in QlikView

Not Getting corrct field value

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Not Getting corrct field value

Tue, 28 Jun 2016 08:13:36 GMT

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!

Re: Not Getting corrct field value

Anonymous — Tue, 28 Jun 2016 08:19:14 GMT

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

Re: Not Getting corrct field value

Tue, 28 Jun 2016 08:52:30 GMT

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.

Re: Not Getting corrct field value

Tue, 28 Jun 2016 09:30:44 GMT

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!

Re: Not Getting corrct field value

PrashantSangle — Tue, 28 Jun 2016 09:48:32 GMT

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

Re: Not Getting corrct field value

Tue, 28 Jun 2016 09:50:26 GMT

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

Re: Not Getting corrct field value

juleshartley — Tue, 28 Jun 2016 09:52:55 GMT

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.

Re: Not Getting corrct field value

Tue, 28 Jun 2016 09:54:31 GMT

Yes it is true/false field.

Re: Not Getting corrct field value

Anonymous — Tue, 28 Jun 2016 10:06:03 GMT

Read on this discussion

On Boolean Fields and Functions

Re: Not Getting corrct field value

susovan — Tue, 28 Jun 2016 11:12:32 GMT

Hi Abhishek,

You also try this in your script,

Table:

LOAD * INLINE [

Field

];

LOAD*,

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

Re: Not Getting corrct field value

Tue, 28 Jun 2016 11:17:14 GMT

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.

Re: Not Getting corrct field value

Kushal_Chawda — Tue, 28 Jun 2016 11:20:28 GMT

How that dimension is calculated in script

Re: Not Getting corrct field value

Tue, 28 Jun 2016 11:23:04 GMT

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

Re: Not Getting corrct field value

ramasaisaksoft — Tue, 28 Jun 2016 11:31:26 GMT

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.