Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
does anybody know if there is an option in qlikview to create a list box with the names of expressions of pivot table?
You can xml load your qvw file, the expression label is in the label field.
DocumentSummary:
LOAD GenerateLogfile,
[LineageInfo/Discriminator] as Discriminator,
[Dimension/ObjectId],
[Dimension/PseudoDef] as PseudoDef,
[Expression/ObjectId],
[Expression/Definition] as Definition,
[Expression/Label] as Label,
[SheetObject/ObjectId],
[SheetObject/Caption] as Caption,
[SheetObject/Type] as Type,
[Sheet/SheetId] as SheetId,
[Sheet/Title] as Title,
%Key_DocumentSummary_3E3ED09C8BC69525 // Key for this table: DocumentSummary
FROM YourQVW.qvw (XmlSimple, Table is [DocumentSummary]);
If you just need it from this one pivot table add a where [SheetObject/ObjectId]='YourChartID'
You can create an Inline Table for KPIs and use them in Pivot Table
or dynamically using a macro.
But how will you use them, once you have them in a list box?
as per my knowledge currently we do not have any option to get the list of expression name outside the charts.
you can try with macro , why you need this??
Check enclosed file....
You can xml load your qvw file, the expression label is in the label field.
DocumentSummary:
LOAD GenerateLogfile,
[LineageInfo/Discriminator] as Discriminator,
[Dimension/ObjectId],
[Dimension/PseudoDef] as PseudoDef,
[Expression/ObjectId],
[Expression/Definition] as Definition,
[Expression/Label] as Label,
[SheetObject/ObjectId],
[SheetObject/Caption] as Caption,
[SheetObject/Type] as Type,
[Sheet/SheetId] as SheetId,
[Sheet/Title] as Title,
%Key_DocumentSummary_3E3ED09C8BC69525 // Key for this table: DocumentSummary
FROM YourQVW.qvw (XmlSimple, Table is [DocumentSummary]);
If you just need it from this one pivot table add a where [SheetObject/ObjectId]='YourChartID'