topic variable store limit in a macro in QlikView https://community.qlik.com/t5/QlikView/variable-store-limit-in-a-macro/m-p/156078#M32085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the following in a macro: <B></B></P><P style="font-weight: bold">set</P><B></B><P style="font-weight: bold"></P>myfield = ActiveDocument.Fields("ACCTNUM").GetPossibleValues() <BR /><BR /> <P></P><P>the field ACCTNUM has more than 300 values, but myfield only have 100, I think there is a limit of values a variable can store.</P><P>Does enyone knows a workaround for this problem?</P><P>Thank you</P></BODY></HTML> Wed, 05 Jan 2011 20:29:36 GMT 2011-01-05T20:29:36Z variable store limit in a macro https://community.qlik.com/t5/QlikView/variable-store-limit-in-a-macro/m-p/156078#M32085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the following in a macro: <B></B></P><P style="font-weight: bold">set</P><B></B><P style="font-weight: bold"></P>myfield = ActiveDocument.Fields("ACCTNUM").GetPossibleValues() <BR /><BR /> <P></P><P>the field ACCTNUM has more than 300 values, but myfield only have 100, I think there is a limit of values a variable can store.</P><P>Does enyone knows a workaround for this problem?</P><P>Thank you</P></BODY></HTML> Wed, 05 Jan 2011 20:29:36 GMT https://community.qlik.com/t5/QlikView/variable-store-limit-in-a-macro/m-p/156078#M32085 2011-01-05T20:29:36Z variable store limit in a macro https://community.qlik.com/t5/QlikView/variable-store-limit-in-a-macro/m-p/156079#M32086 <HTML><HEAD></HEAD><BODY><P>GetPossibleValues returns up to 100 values by default. You can change the default by adding another parameter:</P><P>...GetPossibleValues 10000</P></BODY></HTML> Wed, 05 Jan 2011 20:40:23 GMT https://community.qlik.com/t5/QlikView/variable-store-limit-in-a-macro/m-p/156079#M32086 Oleg_Troyansky 2011-01-05T20:40:23Z