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
