1 Reply Latest reply: Jan 27, 2017 2:07 AM by Yeo Poh sai RSS

    How to use inline load to replace ColumnDim ?

    Yeo Poh sai

      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