Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
poojashribanger
Creator II
Creator II

LINK_Table

I have created a link Table and i am getting values.

but the values which i am getting is reduced by 3 times the original value.

why is it so?

This is my Script

LINK_TABLE:

load distinct *,

upper(date(date))&'-'&upper(IBU) as [%map_Key];

load distinct

[%Key],

upper([Finance Date]) as date,

upper(CDU) as IBU,

upper(Finance_cg) as [Customer group]

Resident VW_FACT_CDG_PNL;

Concatenate(LINK_TABLE)

load distinct *,

upper(date(date))&'-'&upper(IBU) as [%map_Key];

load distinct

[%Key1],

upper(date(TRANSACTION_EFFECTIVE_DT)) as date,

upper(EMPLOYEE_IBU_ID) as IBU,

upper(base_cg) as [Customer group]

Resident TM_RW_BASEDATAVIEW_TBL;

Concatenate(LINK_TABLE)

load distinct *,

upper(date(date))&'-'&upper(IBU) as [%map_Key];

load distinct

[%Key2],

upper(date(MNTH_DT)) as date,

upper(IBU_ID) as IBU,

upper(CUSTOMER_GROUP_NAME) as [Customer group]

Resident Resource_Utilization;

drop Fields

[Finance Date],

CDU,

Finance_cg from VW_FACT_CDG_PNL;

drop Fields

TRANSACTION_EFFECTIVE_DT,

EMPLOYEE_IBU_ID,

base_cg

from TM_RW_BASEDATAVIEW_TBL;

drop Fields

MNTH_DT,

IBU_ID,

CUSTOMER_GROUP_NAME from Resource_Utilization;

0 Replies