formulla

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

Dear ALL

I HAVE GIVEN BELOW SCRIPT

CrossTable(cata, Data,3)

LOAD BCOD,

Category,

Description,

MR,

The Description includes following categories

GROSS PROFIT
Direct Expenses
Apportioned Direct Expenses
Indirect Expenses
Mgt Fee - Apportioned Indirect Expenses
Direct - Other Income
Indirect Income - Investment

I need to derive following formulas by using above category of data

01.

GROSS PROFIT-Direct Expenses-Apportioned Direct Expenses as Profit_aft_Direct_Expenses

02.

GROSS PROFIT-Direct Expenses-Apportioned Direct Expenses+Direct - Other Income as Profit_aft_Direct_Expenses_Income

03.

GROSS PROFIT-Direct Expenses-Apportioned Direct Expenses+Direct - Other Income -Indirect Expenses-Mgt Fee - Apportioned Indirect Expenses as Net_Profit_Before_Income

04.

GROSS PROFIT-Direct Expenses-Apportioned Direct Expenses+Direct - Other Income -Indirect Expenses-Mgt Fee - Apportioned Indirect Expenses+Indirect Income - Investment as Net_Profit_Before_Income

sagara

Re: formulla

Siva_Sankar — Mon, 24 Jul 2017 09:39:19 GMT

Hi Sagara,

You can create a calculated field like below and then use it in expression.

Load *,

if(Category='GROSS PROFIT',Category) as GROSS PROFIT,

if(Category='Direct Expenses',Category) as Direct Expenses,

.....

......

....

FROM YOUR TABLE;

-Siva

topic Re: formulla in QlikView

formulla

Re: formulla