topic Re: dynamic pivot table always last dimension needed in QlikView https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443199#M165177 <HTML><HEAD></HEAD><BODY><P>no in qv10 </P><P>the only way to do it is with macros</P></BODY></HTML> Tue, 23 Oct 2012 09:21:39 GMT lironbaram 2012-10-23T09:21:39Z dynamic pivot table always last dimension needed https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443196#M165174 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I came across a problem. I have a pivot table that is being built dynamicly. So I never know what dimesion my chart will have in my expression I'm using the aggr() function so how can I built the aggr() function with all the dimensions?? is there any way?</P><P>so sometimes my chart has the dimensions store, ProductID or Store, Model, ProductID or Saison, ProductName and so on I can have up to 12 dimensions. It would be cool if anyone has and idea how to solve this problem or if anyone lets me know that this problem can't be solved</P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Tue, 23 Oct 2012 08:16:15 GMT https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443196#M165174 2012-10-23T08:16:15Z Re: dynamic pivot table always last dimension needed https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443197#M165175 <HTML><HEAD></HEAD><BODY><P>hi attach is an example</P><P></P><P>you have a table that it build dinamicly by selecting dimensions</P><P></P><P>look at the third expresssion in the aggr argument i use a variable who holds the selected Dimensions</P><P></P><P>that way it is doing the aggr dynamicly on the selected dimensions</P><P></P><P>hope it helps you</P></BODY></HTML> Tue, 23 Oct 2012 09:02:10 GMT https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443197#M165175 lironbaram 2012-10-23T09:02:10Z Re: dynamic pivot table always last dimension needed https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443198#M165176 <HTML><HEAD></HEAD><BODY><P>Hey thank you it helps alot I just have to try it out now and now I know how I can create a dynamic chart without a macro!!! Was this already possible like that in qv10?</P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Tue, 23 Oct 2012 09:14:12 GMT https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443198#M165176 2012-10-23T09:14:12Z Re: dynamic pivot table always last dimension needed https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443199#M165177 <HTML><HEAD></HEAD><BODY><P>no in qv10 </P><P>the only way to do it is with macros</P></BODY></HTML> Tue, 23 Oct 2012 09:21:39 GMT https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443199#M165177 lironbaram 2012-10-23T09:21:39Z Re: dynamic pivot table always last dimension needed https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443200#M165178 <HTML><HEAD></HEAD><BODY><P>ok we just changed to qv11 so i will start changing it to the way you did it it seems to be a lot faster can I do it the same way for expressions?</P><P></P><P>regards</P></BODY></HTML> Tue, 23 Oct 2012 09:24:15 GMT https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443200#M165178 2012-10-23T09:24:15Z Re: dynamic pivot table always last dimension needed https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443201#M165179 <HTML><HEAD></HEAD><BODY><P>yes yo can look at the expressions in the table </P><P></P><P>in the expresssion tab properties </P><P>you can check the conditional check box </P><P>the use the expression list in the screen</P></BODY></HTML> Tue, 23 Oct 2012 09:34:55 GMT https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443201#M165179 lironbaram 2012-10-23T09:34:55Z Re: dynamic pivot table always last dimension needed https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443202#M165180 <HTML><HEAD></HEAD><BODY><P>thanks again for the example it helped me alot with a couple of things <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Tue, 23 Oct 2012 10:41:38 GMT https://community.qlik.com/t5/QlikView/dynamic-pivot-table-always-last-dimension-needed/m-p/443202#M165180 2012-10-23T10:41:38Z