topic Re: Max variable size? in QlikView

Max variable size?

stjernvd — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am creating a variable in my script with around 9,000 numbers, they are separated like this, '1234','1233', etc..

The size is constantly 9,000 numbers, but I worry this may be too big and maybe the variable isnt capturing all the numbers, its very hard to check.

9000 numbers isnt too big for the variable to handle is it?

Re: Max variable size?

sunny_talwar — Fri, 15 Apr 2016 17:29:13 GMT

I don't think there should be an issue, but why are you doing this? May be there is another better way to do this because you are always going to worry about checking if those 9000 values are there or not

Re: Max variable size?

Chanty4u — Fri, 15 Apr 2016 17:30:13 GMT

chk dis

https://community.qlik.com/message/647172#647172

Re: Max variable size?

stjernvd — Fri, 15 Apr 2016 17:51:30 GMT

I have a table with a list of Product IDs that I don't want to be pulled in another table.

IDs:

Load

ProductIDs

From

xxx

Where Purchase = 'RETURNED';

Main:

Load

ProductIDs,

etc,

From

xxx

Where not exists (Product IDs);

But this wouldnt work so I made ProductIDs in the IDs table as a variable instead and then in the Main table Where ProductIDs(not match ('$(variable') but this isn't the best approach due the reasons ive listed above.

Any ideas on why my where not exists isnt working?

Re: Max variable size?

sunny_talwar — Fri, 15 Apr 2016 17:55:20 GMT

First of all, I am guessing this was a typo -> Where not exists (Product IDs); -> Where not exists (ProductIDs);(Should be without any space, since both your fields name don't have space)

Second, Do you have ProductIDs elsewhere in the script before you bring these two tables in?

Re: Max variable size?

stjernvd — Fri, 15 Apr 2016 17:57:27 GMT

Yes it was a typo sorry!

No I don't, the first time I bring ProductIDs in is in the IDs table...

Re: Max variable size?

sunny_talwar — Fri, 15 Apr 2016 18:00:46 GMT

I don't see why the above script won't work. Can you share the whole script, may be we are missing something which is not shared here?

Re: Max variable size?

johnw — Fri, 15 Apr 2016 23:26:01 GMT

Assuming ProductIDs isn't the key to the table, then the script doesn't work because in the second load, you'll only get the very first record for any given ProductIDs. After that, the ProductIDs exists, so you won't load any further records for it. The solution would be to load the first field as ReturnedProductIDs, and do not exists(ReturnedProductIDs, ProductIDs). That's my guess, anyway. I wasn't exactly clear what wasn't working, just that it wasn't working as you expected.