Field missing

[#1]

Hi

I am new to qlikview and would like to know how can I load flowfield from Nav

I tried to type the name of the field in load and / or select without success.

the flow field I need is in the job table "Total Budget"

Thank you for your help

JobTable:

LOAD

    "No_"  AS JobID,

    "Description",

    "Bill-to Customer No_",

    "Creation Date",

    "Allow Precl_ R__Prov_ Loss";

SQL SELECT

  "No_",

    "Description",

    "Bill-to Customer No_",

    "Creation Date",

    "Allow Precl_ R__Prov_ Loss"

FROM test.dbo."db$Job";

[sunny_talwar]

flowfield? What is that? Can you elaborate a little?

[#3]

Hi Sunny

It's a calculated field

[nagarjuna_kotha]

Can u please explain clearly?

So that we ll try to help you.

-Nagarjun

[#5]

HI all

It appears my problem is not clear enough for everyone.

I have on table "Job" the following information, I would like to load field "Total Budget" in Qlikview

Enabled	Field No.	Field Name	Data Type	Length	Description	Field Class
Yes	1	No.	Code	20		Normal
Yes	3	Description	Text	50		Normal
Yes	4	Description 2	Text	50		Normal
Yes	5	Bill-to Customer No.	Code	20		Normal
Yes	12	Creation Date	Date			Normal
Yes	19	Status	Option			Normal
Yes	20	Person Responsible	Code	20		Normal
Yes	29	Last Date Modified	Date			Normal
Yes	58	Name	Text	50		Normal
Yes	67	Country/Region Code	Code	10		Normal
Yes	11012001	Total Budget	Decimal			FlowField

[vinieme12]

Ask the database guys for the exact field name in the Job table and then add as below

JobTable:

LOAD

    "No_"  AS JobID,

    "Description",

    "Bill-to Customer No_",

    "Creation Date",

    "Allow Precl_ R__Prov_ Loss"

     "TOTAL BUDGET"

     ;

SQL SELECT

  "No_",

    "Description",

    "Bill-to Customer No_",

    "Creation Date",

    "Allow Precl_ R__Prov_ Loss"

     "TOTAL BUDGET"

FROM test.dbo."db$Job";

[#7]

I tried it but it's not working

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Invalid column name 'TOTAL BUDGET'.

[vinieme12]

You need to know the exact name of the field in the table/view...ask the Database Admin

[stabben23]

if you have a connection to the database, press select in script. Find your table test.dbo."db$Job"

Here can you see what fields the table have. Pick the one you need.

You can also do as select * and LOAD * to get all fields from the table.

[maxgro]

try with a select * and then in table viewer (CTRL-T) look at the fields you can load

SQL SELECT *

FROM test.dbo."db$Job";