List box with the names of expressions

[#1]

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?

[MK_QSL]

You can create an Inline Table for KPIs and use them in Pivot Table

[giakoum]

or dynamically using a macro.

But how will you use them, once you have them in a list box?

[avinashelite]

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??

[MK_QSL]

Check enclosed file....

[stigchel · Accepted solution]

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'