expression

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 above script Description field includes following data

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 Description field.

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: expression

Anil_Babu_Samineni — Tue, 25 Jul 2017 05:55:57 GMT

Why not using Preceding load or may be Resident load by help of Group By with in the script?

topic Re: expression in QlikView

expression

Re: expression