topic Re: Performance Issue with AdHoc Pivot Table using Conditionals in QlikView https://community.qlik.com/t5/QlikView/Performance-Issue-with-AdHoc-Pivot-Table-using-Conditionals/m-p/460809#M1272335 <HTML><HEAD></HEAD><BODY><P>No thoughts at all on this?&nbsp; I was hoping for something.&nbsp; Does anyone use the conditionals like this on pivot tables and if so how many fields approximately?</P></BODY></HTML> Mon, 25 Mar 2013 10:32:35 GMT 2013-03-25T10:32:35Z Performance Issue with AdHoc Pivot Table using Conditionals https://community.qlik.com/t5/QlikView/Performance-Issue-with-AdHoc-Pivot-Table-using-Conditionals/m-p/460808#M1272332 <HTML><HEAD></HEAD><BODY><P>We have a report that is more of a AdHoc for our users.&nbsp; The report currently has 54 Dimensions with a Enable Conditional and 9 Expressions using Conditional to create this report.&nbsp; The user has a picklist to choose the fields they want to display for the report.&nbsp; The user reduced data down to 4 months worth of Labor data which is about 150,000 rows of data.&nbsp; When the user picks no more than 3-4 fields the report just slows down considerably.&nbsp; Has anyone else tried to use the conditional feature in this way and seen these type of performance issues?&nbsp; I can create a pivot table with those selections specifically and the report flies of course.&nbsp; All this is done in Ajax btw but even in my client I notice performance is horrible.&nbsp; Just showing the user and their total hours which is about 4000 rows of data is horrible in this report.&nbsp; </P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Performance-Issue-with-AdHoc-Pivot-Table-using-Conditionals/m-p/460808#M1272332 2026-01-26T18:19:17Z Re: Performance Issue with AdHoc Pivot Table using Conditionals https://community.qlik.com/t5/QlikView/Performance-Issue-with-AdHoc-Pivot-Table-using-Conditionals/m-p/460809#M1272335 <HTML><HEAD></HEAD><BODY><P>No thoughts at all on this?&nbsp; I was hoping for something.&nbsp; Does anyone use the conditionals like this on pivot tables and if so how many fields approximately?</P></BODY></HTML> Mon, 25 Mar 2013 10:32:35 GMT https://community.qlik.com/t5/QlikView/Performance-Issue-with-AdHoc-Pivot-Table-using-Conditionals/m-p/460809#M1272335 2013-03-25T10:32:35Z