topic Data headings to list box in QlikView https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326633#M1195550 <HTML><HEAD></HEAD><BODY><P>Use the field with the headings as Dimension in the chart</P></BODY></HTML> Wed, 25 May 2011 13:54:40 GMT 2011-05-25T13:54:40Z Data headings to list box https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326629#M1195546 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a quick question.</P><P></P><P>The data is stored in an xls under numerous headings, e.g. % sales achieved, % margin and so on. </P><P></P><P>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?</P></BODY></HTML> Wed, 25 May 2011 11:40:31 GMT https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326629#M1195546 2011-05-25T11:40:31Z Data headings to list box https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326630#M1195547 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>You can do that using crosstable when reading the xls. The headers will become data in qvw</P></BODY></HTML> Wed, 25 May 2011 11:46:37 GMT https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326630#M1195547 2011-05-25T11:46:37Z Data headings to list box https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326631#M1195548 <HTML><HEAD></HEAD><BODY><P>Thanks; found the command structure for cross tables. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 May 2011 12:52:20 GMT https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326631#M1195548 2011-05-25T12:52:20Z Data headings to list box https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326632#M1195549 <HTML><HEAD></HEAD><BODY><P>How do I link this list box to a graph such that the data for these headings can be shown in the graph / table?</P></BODY></HTML> Wed, 25 May 2011 13:51:57 GMT https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326632#M1195549 2011-05-25T13:51:57Z Data headings to list box https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326633#M1195550 <HTML><HEAD></HEAD><BODY><P>Use the field with the headings as Dimension in the chart</P></BODY></HTML> Wed, 25 May 2011 13:54:40 GMT https://community.qlik.com/t5/QlikView/Data-headings-to-list-box/m-p/326633#M1195550 2011-05-25T13:54:40Z