How to use inline load to replace ColumnDim ?

[paulyeo11]

Hi All

My below script work fine :-

For Each i in 101,102

WhatIfDimension$(i):

LOAD * INLINE [

  Pls select $(i)st Dim,Column$(i)

  GP_C,GROUP_CLASS

  YrMth,YearMonth

  CU_ID,CUST_ID

  COY,COMPANY

  ];

NEXT i;

In Qlik Sense i cannot declare variable , So i replace above by inline load to my sales table :-

LOAD * INLINE [

DIM_A,DIM_B

grouping,grouping

sEG,sEG

COMPANY,COMPANY

];

Table 2 is what i am looking for . it can last sales by company.

My table 1 , i want to list sales by company.  it does not display all company name.

My issue is due to inline load does not link DIM_A to COMPANY field to sales table.

Hope some one can share with me.

Paul

[paulyeo11]

my QVW