topic Limitation Feature of Qlik Sense Pivot Table in App Development https://community.qlik.com/t5/App-Development/Limitation-Feature-of-Qlik-Sense-Pivot-Table/m-p/1207621#M23076 <HTML><HEAD></HEAD><BODY><P>I have a pivot table where I only want to show rows that are greater than a certain value. The limitation feature on the pivot table object lets me set a limit and group rows below the limit into a single row called 'Others', but I can't seem to move that row. Additionally, the limitation function only seems to reference the first column of the pivot table.</P><P></P><P>1. Is it possible to move the Others row? I'd rather have it on the bottom than on the top. When I try to sort, it seems like the 'Others' row doesn't move while the other normal rows do.</P><P>2. Is it possible to calculate the limitation off of a measure that's not in the first column? I see in the limitation calculation what measure the limitation refers to, but I can't change it.</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 07 Oct 2016 19:31:41 GMT Anonymous 2016-10-07T19:31:41Z Limitation Feature of Qlik Sense Pivot Table https://community.qlik.com/t5/App-Development/Limitation-Feature-of-Qlik-Sense-Pivot-Table/m-p/1207621#M23076 <HTML><HEAD></HEAD><BODY><P>I have a pivot table where I only want to show rows that are greater than a certain value. The limitation feature on the pivot table object lets me set a limit and group rows below the limit into a single row called 'Others', but I can't seem to move that row. Additionally, the limitation function only seems to reference the first column of the pivot table.</P><P></P><P>1. Is it possible to move the Others row? I'd rather have it on the bottom than on the top. When I try to sort, it seems like the 'Others' row doesn't move while the other normal rows do.</P><P>2. Is it possible to calculate the limitation off of a measure that's not in the first column? I see in the limitation calculation what measure the limitation refers to, but I can't change it.</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 07 Oct 2016 19:31:41 GMT https://community.qlik.com/t5/App-Development/Limitation-Feature-of-Qlik-Sense-Pivot-Table/m-p/1207621#M23076 Anonymous 2016-10-07T19:31:41Z