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";

[vinieme12]

try like 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";

[#3]

Hi all

Thank you for taking time to help me.

Below the table structure and the field I am trying to get. with select * from Job  I manage to get all normal fields but not flowfield.

Is there a way to get Total Budget field?

Thanks

[stabben23]

If this is the same table as above test.dbo."db$Job", then add "Total Budget" in Your Select.

SQL SELECT

  "No_",

    "Description",

    "Bill-to Customer No_",

    "Creation Date",

    "Allow Precl_ R__Prov_ Loss",

     "Total Budget"

FROM test.dbo."db$Job";

[miskin_m]

Hi,

Flow field can only be loaded by left joining with the current table. Look for the original table from where flow fields is coming. Flow field is nothing but it is calculated field for which data is coming from other table. Their is a setting where you will get to know from which table the flow field is coming. Ask database guy for the same.

[tunoi]

Flow fields in Dynamics are not available in the physical table, they are calculated so the only way to get them is to replicate the logic behind them in your script.

[Miguel_Angel_Baeyens]

Hello Adel,

As mentioned above, flow fields are not actual fields in the table, but calculations performed when the flow field is requested, and these are usually not stored back.

For some versions, there is a C/SIDE ODBC native driver which can read from them, but it was discontinued for newer versions.

If you don't have such driver, or not enough licenses to use them, then the only alternative is to indeed replicate the logic in Qlik either in the load script or while doing the SQL query to retrieve the SIFT table with the calculation.

About FlowFields (Microsoft): FlowFields Overview

About SIFT tables (Microsoft): SumIndexField Technology (SIFT)

Miguel

[#8]

Hi Miguel

Thank you for your help

I will try to replicate the logic in Qlik I do not know how to use C/SIDE driver