Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

katetsan
New Contributor II

Scripts for QV and QS

Hi Communities,

I'm trying to copy the script of QV and paste it into QS app.

However, it keeps showing error msg as 'map_id not found'.

Could anyone have the same problem before?

Thanks in advance.

****************** Script ******************

T004T:   // Chart of Account Names

Mapping Load

   KTOPL,

   KTPLT

    ;

Select KTOPL KTPLT  SPRAS

From T004T WHERE SPRAS =1;



[SKAT]:   // G/L Account Master Record (Chart of Accounts: Description)

Load

    SAKNR as [%RACCT_SAKNR_KEY],

   KTOPL,

   ApplyMap('T004T',KTOPL) as [Chart of Accts_Name_KTOPT],

   SAKNR as [G/L Account_SAKNR],

   TXT50 as [Account Number Long Text_TXT50],

   TXT20 as [Account Number Short Text_TXT20],

   MCOD1 as [Account Number Long text_MCOD1];

Select TXT20 KTOPL MCOD1 SAKNR TXT50 SPRAS

From SKAT WHERE SPRAS = 1';

5 Replies
ChennaiahNallani
Contributor III

Re: Scripts for QV and QS

create connecting in Qlik sense and check the path

Capture.PNG

Capture.PNG

katetsan
New Contributor II

Re: Scripts for QV and QS

I do connect to SAP system via Connector.

ChennaiahNallani
Contributor III

Re: Scripts for QV and QS

yeah, But you have to install sap connectors. it's not free

Try or Buy

Luminary
Luminary

Re: Scripts for QV and QS

Change Qlik Sense to legacy mode

Qlik Sense Legacy mode

agigliotti
Honored Contributor II

Re: Scripts for QV and QS

maybe this:

T004T:   // Chart of Account Names

Mapping Load

   KTOPL,

   KTPLT

    ;

Select KTOPL, KTPLT, SPRAS

From T004T WHERE SPRAS =1;


are you missing comma between table columns ?

Community Browser