How to use inline load to replace ColumnDim ?

paulyeo11 — Fri, 27 Jan 2017 07:06:22 GMT

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

Re: How to use inline load to replace ColumnDim ?

paulyeo11 — Fri, 27 Jan 2017 07:07:33 GMT

my QVW