topic Showing KPIs in Pivot table depending on selected chart in QlikView https://community.qlik.com/t5/QlikView/Showing-KPIs-in-Pivot-table-depending-on-selected-chart/m-p/427536#M564866 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a solution where i display charts in a container object (sometimes i show 2 tables in one wiew, via another container). Below I display a Pivot table with the corresponding values as well as budget and accumulated etc. In the Container I have 6 different charts/Views and what I would like to do is to only show the corresponding measures in the pivot table as the ones that are active at the moment in the chart. </P><P></P><P>In other words:</P><P>lets say I have a container (showing one at a time) with one chart for sales and one chart for purchace. When I choose to look at sales I would like the pivot table to only display the figures related to sales. Is it possible to do this in any way. I am using Conditional Layout depending on selected values in dimension but in my current case I do not do any active selections apart from klicking on my "button" for the chart that is displayed in the container.</P><P></P><P>Also, I have noticed that setting conditional shows does make it a little slow is there any way to optimize this?</P><P></P><P>Thank you for any suggestions <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 16 Jan 2013 15:24:09 GMT 2013-01-16T15:24:09Z Showing KPIs in Pivot table depending on selected chart https://community.qlik.com/t5/QlikView/Showing-KPIs-in-Pivot-table-depending-on-selected-chart/m-p/427536#M564866 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a solution where i display charts in a container object (sometimes i show 2 tables in one wiew, via another container). Below I display a Pivot table with the corresponding values as well as budget and accumulated etc. In the Container I have 6 different charts/Views and what I would like to do is to only show the corresponding measures in the pivot table as the ones that are active at the moment in the chart. </P><P></P><P>In other words:</P><P>lets say I have a container (showing one at a time) with one chart for sales and one chart for purchace. When I choose to look at sales I would like the pivot table to only display the figures related to sales. Is it possible to do this in any way. I am using Conditional Layout depending on selected values in dimension but in my current case I do not do any active selections apart from klicking on my "button" for the chart that is displayed in the container.</P><P></P><P>Also, I have noticed that setting conditional shows does make it a little slow is there any way to optimize this?</P><P></P><P>Thank you for any suggestions <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 16 Jan 2013 15:24:09 GMT https://community.qlik.com/t5/QlikView/Showing-KPIs-in-Pivot-table-depending-on-selected-chart/m-p/427536#M564866 2013-01-16T15:24:09Z