Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error Whilst Preforming Calculation

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.

12 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Hi Kaushik,

From where should it be from?

Income and Expenditure are found in different tables

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Ok thank you, I will give that a go.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Sure,

Do let us know if you need any other help.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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
Creator
Creator

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.

Not applicable
Author

Hi Anand,


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

Field 'Income' not found

kvanandan1
Creator
Creator

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;