Not able to create KEY in qliksense script

Aspiring_Developer — Wed, 16 Sep 2020 10:16:11 GMT

Hello All,

I am trying to create a new table and link it with existing ones using Keys.

I tried below and it works in Qlikview:-

New_Fact:
LOAD _KEY_DIM as Key_Dim,
_Key_Ratio as Key_Ratio,
Periode as NEw_Periode,
_Key_Control as KEy_Control,
_KEY_DETAIL as Key_Detail,
KPI_Code as New_KPI_Code,
KPI_Code & Periode & _KEY_DIM as %New_Key,
Nbr_KO as Nbr_Ko,
Nbr_TOTAL as Nbr_Total,
Total_Amount_KO as New_Total_Amount_KO,
Special_Amount1 as NEw_Special_Amount1,
Special_Amount2 as New_Special_Amount2,
Special_Amount3 as New_Special_Amount3,
Total_Amount as New_Total_Amount
FROM

(qvd);

output

When i am doing the same in Qliksense, it is creating new table but no key is created:-

Sense Script:-

New_Fact:
LOAD //_KEY_DIM as Key_Dim,
_Key_Ratio as Key_Ratio,
// Periode as NEw_Periode,
_Key_Control as KEy_Control,
_KEY_DETAIL as Key_Detail,
//KPI_Code as New_KPI_Code,
KPI_Code & '-' & Periode & '-' & _KEY_DIM as %New_Key,
Nbr_KO as Nbr_Ko,
Nbr_TOTAL as Nbr_Total,
Total_Amount_KO as New_Total_Amount_KO,
Special_Amount1 as NEw_Special_Amount1,
Special_Amount2 as New_Special_Amount2,
Special_Amount3 as New_Special_Amount3,
Total_Amount as New_Total_Amount
FROM
(qvd);

Data Model-It is not linking with fact table.

I don't know what is wrong as it works in Qlikview but not in Qliksesne.

Can anyone please help me on this ?

Thanks

@Kushal_Chawda

Re: Not able to create KEY in qliksense script

Aspiring_Developer — Wed, 16 Sep 2020 12:23:02 GMT

I solved it myself. Thanks

topic Re: Not able to create KEY in qliksense script in App Development

Not able to create KEY in qliksense script

Re: Not able to create KEY in qliksense script