Inset a row with fixed data (Mapping table)

Yuhka — Sat, 16 Nov 2024 21:04:20 GMT

Hello guys, I'm new to qlikview.

I have a data which has column : Code, ColumnNo and Price.

When I load to Qlikview, I get Column name and class (in both of ENG and JPN) using Mapping Load as belows.

================================================

ClassEnglish:
Mapping LOAD Map_ColumnNo,
Name
FROM
$(vPathName)Map_ClassENG.xlsx
(ooxml, embedded labels, table is Sheet1);

ClassJapanese:
Mapping LOAD Map_ColumnNo,
Name
FROM
$(vPathName)Map_ClassJPN.xlsx
(ooxml, embedded labels, table is Sheet1);

NameEnglish:
Mapping LOAD Map_ColumnNo,
Name
FROM
$(vPathName)Map_NameENG.xlsx
(ooxml, embedded labels, table is Sheet1);

NameJapanese:
Mapping LOAD Map_ColumnNo,
Name
FROM
$(vPathName)Map_NameJPN.xlsx
(ooxml, embedded labels, table is Sheet1);
///////////////////////////////////////////////////////////

LOAD
Code,
    applymap('ClassEnglish',ColumnNo,'-') as Class_ENG,
    applymap('ClassJapanese',ColumnNo,'-') as Class_JPN,
    applymap('NameEnglish',ColumnNo,'-') as Name_ENG,
    applymap('NameJapanese',ColumnNo,'-') as Name_JPN,
    Price
FROM
$(vPathName)sampledata.xlsx
(ooxml, embedded labels, table is Sheet1);

================================================

Then I created a pivot table with Lang switvhable dimensions. It shows the prices of Shop_A or B regarding the select of Listbox.

Now I would like to insert a row with fixed value in the pivot table. This value is not in the source data and mapping file, so I somehow need to create a data manually.

Also no matter what I select in the Listbox, I would like to insert the fixed row to the pivot table.

Is it possible? Thank you for your big help!

Re: Inset a row with fixed data (Mapping table)

miskinmaz — Thu, 11 Apr 2019 10:43:41 GMT

create an inline table and concat this table to your original table. If by selection you mean selection of shop then code the inline table for both the shop

Re: Inset a row with fixed data (Mapping table)

Yuhka — Fri, 12 Apr 2019 00:15:35 GMT

Hi @miskinmaz ,

Thank you for your advise, but I cannot load both shops Inline manually.

Now I'm testing using only two shops, but if I create a production qvw there is possibility of shop name will change or there might be more columns.

Thank you for your support!

Re: Inset a row with fixed data (Mapping table)

miskinmaz — Fri, 12 Apr 2019 05:32:12 GMT

In this case also u can concat the qvd like

Load
field1,
field2,...
'Type E' as shop,
'Blueberry' as name.
500 as price and so on
from qvd

topic Inset a row with fixed data (Mapping table) in QlikView

Inset a row with fixed data (Mapping table)

Re: Inset a row with fixed data (Mapping table)

Re: Inset a row with fixed data (Mapping table)

Re: Inset a row with fixed data (Mapping table)