topic Re: Including all items in list as expression to chart(Pivot Table) in QlikView https://community.qlik.com/t5/QlikView/Including-all-items-in-list-as-expression-to-chart-Pivot-Table/m-p/678308#M1065770 <HTML><HEAD></HEAD><BODY><P>Hi Kamal</P><P>how many tables are you looking to put in you app as a starting point </P></BODY></HTML> Thu, 11 Sep 2014 14:32:07 GMT Anonymous 2014-09-11T14:32:07Z Including all items in list as expression to chart(Pivot Table) https://community.qlik.com/t5/QlikView/Including-all-items-in-list-as-expression-to-chart-Pivot-Table/m-p/678307#M1065767 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to create a customized table with user selected fields and expression. But stuck... Is there any way to display all selected items as expression... I do not want to list them individually in expression.. What I am trying to do is I will update the list of expression in excel and once I reload the app it should update the chart with added expression in list.</P><P></P><P>Any help would be appreciated..</P><P>Thanks,</P></BODY></HTML> Thu, 11 Sep 2014 13:55:07 GMT https://community.qlik.com/t5/QlikView/Including-all-items-in-list-as-expression-to-chart-Pivot-Table/m-p/678307#M1065767 kamal_sanguri 2014-09-11T13:55:07Z Re: Including all items in list as expression to chart(Pivot Table) https://community.qlik.com/t5/QlikView/Including-all-items-in-list-as-expression-to-chart-Pivot-Table/m-p/678308#M1065770 <HTML><HEAD></HEAD><BODY><P>Hi Kamal</P><P>how many tables are you looking to put in you app as a starting point </P></BODY></HTML> Thu, 11 Sep 2014 14:32:07 GMT https://community.qlik.com/t5/QlikView/Including-all-items-in-list-as-expression-to-chart-Pivot-Table/m-p/678308#M1065770 Anonymous 2014-09-11T14:32:07Z Re: Including all items in list as expression to chart(Pivot Table) https://community.qlik.com/t5/QlikView/Including-all-items-in-list-as-expression-to-chart-Pivot-Table/m-p/678309#M1065772 <HTML><HEAD></HEAD><BODY><P>only one table with multiple fields..</P><P> I have already tried this and now I am looking for some better way.. I have more than 100 fields for expression and it is very difficult to list all of them and then write function for them.. Also it there is any new field is added.. I have to again include that in the list...</P><P>what I am looking for is.. something like this.. _metrics is the header of list</P><P></P><P>I have done this...</P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-607420-66558/tbl.jpg"><IMG alt="tbl.jpg" class="jive-image jiveImage" height="376" src="https://community.qlik.com/legacyfs/online/66572_tbl.jpg" width="658" /></A></P><P></P><P></P><P>I want to do this...</P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-607420-66557/tbl1.jpg"><IMG alt="tbl1.jpg" class="jive-image jiveImage" height="453" src="https://community.qlik.com/legacyfs/online/66573_tbl1.jpg" width="650" /></A></P></BODY></HTML> Thu, 11 Sep 2014 14:56:14 GMT https://community.qlik.com/t5/QlikView/Including-all-items-in-list-as-expression-to-chart-Pivot-Table/m-p/678309#M1065772 kamal_sanguri 2014-09-11T14:56:14Z Re: Including all items in list as expression to chart(Pivot Table) https://community.qlik.com/t5/QlikView/Including-all-items-in-list-as-expression-to-chart-Pivot-Table/m-p/678310#M1065773 <HTML><HEAD></HEAD><BODY><P>Maybe something like this?</P><P><A href="https://community.qlik.com/docs/DOC-6464">Dynamic Tables - An alternative approach to CONCAT using BIT operators</A></P></BODY></HTML> Thu, 11 Sep 2014 15:20:33 GMT https://community.qlik.com/t5/QlikView/Including-all-items-in-list-as-expression-to-chart-Pivot-Table/m-p/678310#M1065773 mjayachandran 2014-09-11T15:20:33Z