Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiply Inline field with a resident field

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

Labels (1)
0 Replies