topic Re: GetFieldSelections... starting with NOT in QlikView https://community.qlik.com/t5/QlikView/GetFieldSelections-starting-with-NOT/m-p/761912#M473191 <HTML><HEAD></HEAD><BODY><P>Use the maxvalues parameter.</P><P></P><P>For example GetfieldSelections(month, , 12)</P></BODY></HTML> Mon, 17 Nov 2014 17:01:06 GMT marcus_malinow 2014-11-17T17:01:06Z GetFieldSelections... starting with NOT https://community.qlik.com/t5/QlikView/GetFieldSelections-starting-with-NOT/m-p/761911#M473190 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>In a previous post <A href="https://community.qlik.com/thread/142360">Two expressions - for the second, show only totals</A>, I have managed to show only the totals for a second dimension (well, treating it as an expression).</P><P></P><P>Now I need to finish that chart, and I am using <EM><STRONG>GetFieldSelections</STRONG></EM> to show / hide different columns.</P><P></P><P>And I am using <EM><STRONG>GetFieldSelections</STRONG></EM> to take into account some columns' values to calculate the totals.</P><P></P><P>The main problem is the value&nbsp; of <EM><STRONG>GetFieldSelections</STRONG></EM>, when it comes to Months:&nbsp; If select from January to September, the <STRONG><EM>GetFieldSelections(Month)</EM></STRONG> function will return a value that&nbsp; starts with NOT (<STRONG>NOT oct, nov, dic</STRONG>)</P><P></P><P>Is it possible to "force" this function, or any other, to retrieve the values of the selected Months?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Mon, 17 Nov 2014 16:59:09 GMT https://community.qlik.com/t5/QlikView/GetFieldSelections-starting-with-NOT/m-p/761911#M473190 salto 2014-11-17T16:59:09Z Re: GetFieldSelections... starting with NOT https://community.qlik.com/t5/QlikView/GetFieldSelections-starting-with-NOT/m-p/761912#M473191 <HTML><HEAD></HEAD><BODY><P>Use the maxvalues parameter.</P><P></P><P>For example GetfieldSelections(month, , 12)</P></BODY></HTML> Mon, 17 Nov 2014 17:01:06 GMT https://community.qlik.com/t5/QlikView/GetFieldSelections-starting-with-NOT/m-p/761912#M473191 marcus_malinow 2014-11-17T17:01:06Z Re: GetFieldSelections... starting with NOT https://community.qlik.com/t5/QlikView/GetFieldSelections-starting-with-NOT/m-p/761913#M473192 <HTML><HEAD></HEAD><BODY><P>Thank you! I didn't know this option.</P><P></P><P>Cheers!</P></BODY></HTML> Mon, 17 Nov 2014 17:03:36 GMT https://community.qlik.com/t5/QlikView/GetFieldSelections-starting-with-NOT/m-p/761913#M473192 salto 2014-11-17T17:03:36Z