topic Re: Change multiple pivot tables simultaneously. in QlikView https://community.qlik.com/t5/QlikView/Change-multiple-pivot-tables-simultaneously/m-p/134344#M20136 <HTML><HEAD></HEAD><BODY><P>Each chart contains different expressions, such as sales, quantity, or cost. Each of these in turn have calculated columns based on age. When I make a selection in the Quantity table, I would like the exact same selections in the sales and cost tables. Does that make sense? </P></BODY></HTML> Fri, 26 Oct 2018 17:34:28 GMT nancymarmat 2018-10-26T17:34:28Z Change multiple pivot tables simultaneously. https://community.qlik.com/t5/QlikView/Change-multiple-pivot-tables-simultaneously/m-p/134342#M20134 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif; color: #575757;">I have qvw that contains multiple charts (pivot tables). Each has the same dimensions, but different expressions. When I expand, collapse, or select a particular row in one pivot table I would like the same selections made in ALL pivot tables. Is that possible? </SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif; color: #575757;">Any help would be greatly appreciated.</SPAN></P></BODY></HTML> Wed, 24 Oct 2018 17:47:38 GMT https://community.qlik.com/t5/QlikView/Change-multiple-pivot-tables-simultaneously/m-p/134342#M20134 nancymarmat 2018-10-24T17:47:38Z Re: Change multiple pivot tables simultaneously. https://community.qlik.com/t5/QlikView/Change-multiple-pivot-tables-simultaneously/m-p/134343#M20135 <HTML><HEAD></HEAD><BODY><P>I believe you will need macros.</P><P>But can i ask if dimensions are exactly the same. Why not use 1 table instead of 2</P></BODY></HTML> Wed, 24 Oct 2018 18:32:47 GMT https://community.qlik.com/t5/QlikView/Change-multiple-pivot-tables-simultaneously/m-p/134343#M20135 dplr-rn 2018-10-24T18:32:47Z Re: Change multiple pivot tables simultaneously. https://community.qlik.com/t5/QlikView/Change-multiple-pivot-tables-simultaneously/m-p/134344#M20136 <HTML><HEAD></HEAD><BODY><P>Each chart contains different expressions, such as sales, quantity, or cost. Each of these in turn have calculated columns based on age. When I make a selection in the Quantity table, I would like the exact same selections in the sales and cost tables. Does that make sense? </P></BODY></HTML> Fri, 26 Oct 2018 17:34:28 GMT https://community.qlik.com/t5/QlikView/Change-multiple-pivot-tables-simultaneously/m-p/134344#M20136 nancymarmat 2018-10-26T17:34:28Z Re: Change multiple pivot tables simultaneously. https://community.qlik.com/t5/QlikView/Change-multiple-pivot-tables-simultaneously/m-p/134345#M20137 <HTML><HEAD></HEAD><BODY><P>apparently even macros cant help you. see below</P><P><A href="https://community.qlik.com/thread/186125">how to get the expand status when the pivot table is expand</A></P></BODY></HTML> Fri, 26 Oct 2018 18:48:30 GMT https://community.qlik.com/t5/QlikView/Change-multiple-pivot-tables-simultaneously/m-p/134345#M20137 dplr-rn 2018-10-26T18:48:30Z