I would love to do that. But where are these fields? They are not in the Script.
The HIERARCHY-Function is building this fields.
Could you please tell me where I can rename them?
HIERARCHY(NodeID, ParentID, NodeName, ParentName ,Node_Bezeichnung ,Hierarchie_PathName, '/' ,Depth )
NodeName as Node_Bezeichnung
[U:\Qlikview Tutorial\Hilfeanfragen\Hierarchy Bipo\Hierarchy BIPO.xlsx]
(ooxml, embedded labels, table is [Hierarchy BIPO]);
To rename the fields you can end the script with:
Mapping Load FromFieldName, ToFieldName Inline
Rename Fields Using FieldNameMap;
To create a better Pivot table, I would do the following:
- Create Pivot table
- Add the 4 levels as Dimensions
- Add Expression - Sum(Sales)? Or just '1' when you test.
- Style - Indent Mode
- Perhaps: Style - Use Only First Dimension Label
- Presentation - Subtotals on top
the first step worked very well. Thanks.
Just one additional question:
Can I also load the remap from Excel.
I tried this but it did not work.
(ooxml, embedded labels, table is Hierarchie_Namen);
Rename Fields using FieldNameMapping;
one last question. How can I get the relation?
I have a field named postrulecode with the same entries and I wanted to match.
But in this case, Qlikview keeps the Name "NodeName4" and does not match.
Every other name I choose will be accepted but then I have no link.
Can you please help me again?
From_Field_Name To_Field_Name NodeName1 RepLayout NodeName2 Hauptgruppe NodeName3 Bipo NodeName4 postrulecode
The Rename statement can rename fields, but it cannot rename two different fields into one. The rename fails if there already exists a field with the target name. This is the reason why NodeName4 isn't renamed.
What you can do, is to load the Postrules table after the Rename statement. That will work.