topic Difficult Top N Pivot in QlikView https://community.qlik.com/t5/QlikView/Difficult-Top-N-Pivot/m-p/206050#M62310 <HTML><HEAD></HEAD><BODY><P></P><DIV style="font-size: 12px; margin: 8px; color: #000000; font-family: Arial, Helvetica, sans-serif; background-color: #ffffff; background-origin: initial; background-clip: initial;"><P>I'd appreciate it if someone can take a look at my attached application and tell me why the Top N pivot isn't working right. It's displaying the dimensions and expression just as I need it but the number of Top N rows doesn't match the variable set by the slider.</P></DIV><BR /><BR /></BODY></HTML> Tue, 08 Feb 2011 18:23:41 GMT Anonymous 2011-02-08T18:23:41Z Difficult Top N Pivot https://community.qlik.com/t5/QlikView/Difficult-Top-N-Pivot/m-p/206050#M62310 <HTML><HEAD></HEAD><BODY><P></P><DIV style="font-size: 12px; margin: 8px; color: #000000; font-family: Arial, Helvetica, sans-serif; background-color: #ffffff; background-origin: initial; background-clip: initial;"><P>I'd appreciate it if someone can take a look at my attached application and tell me why the Top N pivot isn't working right. It's displaying the dimensions and expression just as I need it but the number of Top N rows doesn't match the variable set by the slider.</P></DIV><BR /><BR /></BODY></HTML> Tue, 08 Feb 2011 18:23:41 GMT https://community.qlik.com/t5/QlikView/Difficult-Top-N-Pivot/m-p/206050#M62310 Anonymous 2011-02-08T18:23:41Z Difficult Top N Pivot https://community.qlik.com/t5/QlikView/Difficult-Top-N-Pivot/m-p/206051#M62311 <HTML><HEAD></HEAD><BODY><P>Brian,</P><P>I'm not sure if this is coincidence or the cause of the problem but when you deselect 'Supress When Value is Null' on the first and third dimension of your table, the slider's value is no longer ignored.</P><P>Shane</P></BODY></HTML> Tue, 08 Feb 2011 19:57:13 GMT https://community.qlik.com/t5/QlikView/Difficult-Top-N-Pivot/m-p/206051#M62311 2011-02-08T19:57:13Z Difficult Top N Pivot https://community.qlik.com/t5/QlikView/Difficult-Top-N-Pivot/m-p/206052#M62312 <HTML><HEAD></HEAD><BODY><P>No, it still won't show the proper number of top customers. But I need to suppress nulls in those dimensions anyway, so that's not the issue.</P></BODY></HTML> Tue, 08 Feb 2011 20:05:43 GMT https://community.qlik.com/t5/QlikView/Difficult-Top-N-Pivot/m-p/206052#M62312 Anonymous 2011-02-08T20:05:43Z