Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data headings to list box

Hi,

I have a quick question.

The data is stored in an xls under numerous headings, e.g. % sales achieved, % margin and so on.

How would it be possible to usethese headings and create a list box such that the user can choose the specific variables they wish to see in a graph?

4 Replies
Not applicable
Author

Hi,

You can do that using crosstable when reading the xls. The headers will become data in qvw

Not applicable
Author

Thanks; found the command structure for cross tables.

Not applicable
Author

How do I link this list box to a graph such that the data for these headings can be shown in the graph / table?

Not applicable
Author

Use the field with the headings as Dimension in the chart