topic Re: To add Value in Field in QlikView

To add Value in Field

abhaysingh — Tue, 26 May 2015 09:35:33 GMT

Hi Every one

Can Any one pls help me in this below..

I have one table which contain a field FIELD1 having four value in that i.e. cost, revenue, Deprecation, Amortization and i want to add Gain, Ebit, Gain %, Ebit% in same Filed FIELD1

HOW i can do this

Re: To add Value in Field

robert_mika — Tue, 26 May 2015 09:41:36 GMT

How does your data set look like?

Are the fields to be added coming from different data set or are they calculated?

If the latest, how?

Re: To add Value in Field

abhaysingh — Tue, 26 May 2015 09:43:24 GMT

they are calculated like for gain it is some of Revenue + Cost ans so on

Re: To add Value in Field

alexandros17 — Tue, 26 May 2015 09:43:29 GMT

Load FIELD1 resident myTable;

concatenate

Load * inline [

FIELD1

Gain,

Ebit,

Gain %,

Ebit%

];

let me know

Re: To add Value in Field

robert_mika — Tue, 26 May 2015 10:14:43 GMT

Does your data model look similar to this?

Field1	Field2
Ravenue	100
Cost	200
Depraciation	300

Re: To add Value in Field

abhaysingh — Tue, 26 May 2015 10:26:27 GMT

yes now i want GAIN which is the sum of Revenue+Cost,, and so on