topic Re: ALL in Dimension Limits in QlikView https://community.qlik.com/t5/QlikView/ALL-in-Dimension-Limits/m-p/687403#M1084708 <HTML><HEAD></HEAD><BODY><P>Thanks Jerem... that works !</P></BODY></HTML> Mon, 16 Jun 2014 13:17:19 GMT 2014-06-16T13:17:19Z ALL in Dimension Limits https://community.qlik.com/t5/QlikView/ALL-in-Dimension-Limits/m-p/687401#M1084706 <HTML><HEAD></HEAD><BODY><P>Hi All </P><P></P><P>I have a requirement where the user will be choosing the value for 'Top N' through an Input box. </P><P>The Input Box should have values like 20, 30, 40, ALL. When ALL is selected, it should show all the values in the table and not Top N. </P><P></P><P>How to achieve this? I am able to do it for 20,30,40 but ALL is a problem. Please advise. </P><P></P><P>Paramita </P></BODY></HTML> Mon, 16 Jun 2014 12:49:45 GMT https://community.qlik.com/t5/QlikView/ALL-in-Dimension-Limits/m-p/687401#M1084706 2014-06-16T12:49:45Z Re: ALL in Dimension Limits https://community.qlik.com/t5/QlikView/ALL-in-Dimension-Limits/m-p/687402#M1084707 <HTML><HEAD></HEAD><BODY><P>Use a formula like:</P><P></P><P>=count({1}distinct DIMENSION)</P><P></P><P>in the value for the dimension limits.</P><P></P><P>Hope this helps!</P></BODY></HTML> Mon, 16 Jun 2014 12:58:24 GMT https://community.qlik.com/t5/QlikView/ALL-in-Dimension-Limits/m-p/687402#M1084707 jerem1234 2014-06-16T12:58:24Z Re: ALL in Dimension Limits https://community.qlik.com/t5/QlikView/ALL-in-Dimension-Limits/m-p/687403#M1084708 <HTML><HEAD></HEAD><BODY><P>Thanks Jerem... that works !</P></BODY></HTML> Mon, 16 Jun 2014 13:17:19 GMT https://community.qlik.com/t5/QlikView/ALL-in-Dimension-Limits/m-p/687403#M1084708 2014-06-16T13:17:19Z