Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List box with the names of expressions

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?

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

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'

View solution in original post

5 Replies
MK_QSL
MVP
MVP

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

giakoum
Partner - Master II
Partner - Master II

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

Check enclosed file....

stigchel
Partner - Master
Partner - Master

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'