Error Whilst Preforming Calculation

[#1]

Hi,

I am trying to preform the following calculation:

Load

Income / Expenditure as TotalCostCoverage;

When I load the script I get the following error:

Field 'Income' not found

The error occurred here:

?

Why is this happening?

Please let me know if you need anymore data from me.

[kaushiknsolanki]

Hi,

I can see that From statement is missing.

If it is there, then check if there is Income field coming from your data source.

Also make sure that field name is same as qlik is case sensitive.

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

From where should it be from?

Income and Expenditure are found in different tables

[kaushiknsolanki]

Hi,

If they are found in different tables then you will have to join those tables to bring both the fields in single table and then only you can perform that divide operation on them.

Regards,

Kaushik Solanki

[#5]

Ok thank you, I will give that a go.

[kaushiknsolanki]

Sure,

Do let us know if you need any other help.

Regards,

Kaushik Solanki

[#7]

Hi Kaushik,

I have tried giving outer joining the tables together but I haven't succeeded. Would it be possible for you to give me some guidance?

[kvanandan1]

Hi Alison,

Please use below script:

t1:

LOAD * INLINE [

    Dim1,Income

    A,1

    B,2

    C,3

];

inner join (t1)

LOAD * INLINE [

    Dim1,Expenditure

    A,1

    B,2

    C,3

];

Load Income / Expenditure as TotalCostCoverage;

t3:

Load * Resident t1;

Thanks.

[#9]

Hi Anand,

Thank you for your response. When I insert the script I get this error:

Field 'Income' not found

[kvanandan1]

Hi Alison,

Please try

t1:

LOAD * INLINE [

    Dim1,Income

    A,1

    B,2

    C,3

];

inner join (t1)

LOAD * INLINE [

    Dim1,Expenditure

    A,1

    B,2

    C,3

];

t2:

Load *,Income / Expenditure as TotalCostCoverage Resident t1;

drop table t1;