Multiply Inline field with a resident field

Sat, 05 Apr 2014 22:31:58 GMT

Hi All,

I know this will be simple you the QV guru out there and thanks in advance.

I have an inline table with 3 field. I will like to multiply in field in inline table with another resident field and repeat this 10 time to produce a new table.

So here is the data

Table1:

Key,

Key2

Key3

from xxxx;

Adjustment_Percentage:

LOAD * INLINE [

Weighting, Initial - headcount, Initial - percentage, Normalised excluding non-daily readers, Adjustment for survey hits

A, "1,198", 23.7%, 44.0%, 44.0%

B, 365, 7.2%, 13.4%, 13.4%

C, 53, 1.0%, 1.9%, 1.9%

D, 107, 2.1%, 3.9%, 3.9%

E, 12, 0.2%, 0.4%, 0.4%

AB, 277, 5.5%, 10.2%, 5.1%

AC, 38, 0.8%, 1.4%, 0.7%

AD, 29, 0.6%, 1.1%, 0.5%

AE, 5, 0.1%, 0.2%, 0.1%

BC, 46, 0.9%, 1.7%, 0.8%

BD, 111, 2.2%, 4.1%, 2.0%

BE, 49, 1.0%, 1.8%, 0.9%

CD, 21, 0.4%, 0.8%, 0.4%

CE, 1, 0.0%, 0.0%, 0.0%

DE, 31, 0.6%, 1.1%, 0.6%

ABC, 46, 0.9%, 1.7%, 0.6%

ABD, 43, 0.8%, 1.6%, 0.5%

ABE, 35, 0.7%, 1.3%, 0.4%

ACD, 13, 0.3%, 0.5%, 0.2%

ACE, 1, 0.0%, 0.0%, 0.0%

ADE, 10, 0.2%, 0.4%, 0.1%

BCD, 35, 0.7%, 1.3%, 0.4%

BCE, 3, 0.1%, 0.1%, 0.0%

BDE, 65, 1.3%, 2.4%, 0.8%

CDE, 8, 0.2%, 0.3%, 0.1%

ABCD, 22, 0.4%, 0.8%, 0.2%

ABCE, 5, 0.1%, 0.2%, 0.0%

ABDE, 40, 0.8%, 1.5%, 0.4%

ACDE, 2, 0.0%, 0.1%, 0.0%

BCDE, 26, 0.5%, 1.0%, 0.2%

ABCDE, 24, 0.5%, 0.9%, 0.2%

];

So I will like to Multiply Key with Adjustment for survey hits.

Thanks attached is the data

topic Multiply Inline field with a resident field in QlikView

Multiply Inline field with a resident field