topic Storing values in a Variable in macro code in QlikView

Storing values in a Variable in macro code

rohan_mulay — Mon, 14 Mar 2016 07:35:52 GMT

HI all,

I have written a macro code to send a service SMS to customers. I have used a Variable 'var' in macro that stores the mobile nos. of customers. These mobile nos. are picked from a field named 'Mobile' that is present in the data model.

My concern is when this variable 'var' stores only 100 records. Thus when 'Mobile field has more than 100 records, the SMS is sent only to 100 customers.

Refer following code that I used to store values in variable 'var' :

Set val=ActiveDocument.Fields("Mobile").GetPossibleValues

Kindly provide me a solution by which I can store more records in a variable.

Re: Storing values in a Variable in macro code

marcus_sommer — Mon, 14 Mar 2016 12:23:12 GMT

There is no limitation to a variable and/or a field t 100 entries. I think your limitation is more from your provider to avoid spamming.

- Marcus

Re: Storing values in a Variable in macro code

sfatoux72 — Mon, 14 Mar 2016 12:41:36 GMT

Yes, there is a limitation.

I had the same issue two years ago.

The solution is very simple. The function GetPossibleValues has two optional parameters.

The first one define the maximum number of returned values (default is 100)

Use for example:

Set val=ActiveDocument.Fields("Mobile").GetPossibleValues(1000)

Re: Storing values in a Variable in macro code

marcus_sommer — Mon, 14 Mar 2016 13:01:35 GMT

Very interesting - I have never noticed this limitation probably because the fields was already limited through other selections and most often I use tableboxes to get my values, like: Re: vb scrip to display name.

- Marcus

Re: Storing values in a Variable in macro code

sfatoux72 — Fri, 18 Mar 2016 12:29:06 GMT

Hi,

Please validate the correct answer to help others.

Re: Storing values in a Variable in macro code

anilkumarmishra — Tue, 30 Apr 2019 09:26:59 GMT

Please share the complete code of macro.