topic Re: maximum length of variable? in QlikView

maximum length of variable?

sundarakumar — Sun, 02 Nov 2014 10:38:06 GMT

Hi experts,

Can anyone pls tell me the maximum number of charecters a variable can hold? Would also like to know how many charecters a search string can hold.

The req is that user wants to search for a large number of policy numbers. They would have it in a text doc and copy paste it into qlikview to get the results for those policies.

Am planing to give them an input box and a button to apply selection with triggers.

Is there a better way to achieve this?

Regards,

Sundar

Re: maximum length of variable?

ashfaq_haseeb — Sun, 02 Nov 2014 10:40:22 GMT

A similar Solution attached.

What is the length of your policy number. Qlik Can handle quiet big amount of data.

Regards

ASHFAQ

Re: maximum length of variable?

sundarakumar — Sun, 02 Nov 2014 10:54:17 GMT

Thanks for the reply. Policy numbers are of 10 digits. But at a time user may want to search for 5 lack policies even. Will variable hold them?

I could not check the attachment for next 17 hrs. Am out

-sundar

Re: maximum length of variable?

ashfaq_haseeb — Sun, 02 Nov 2014 11:02:48 GMT

HI,

I'm not really sure on how many values it stores may be Henric Cronström Can confirm this.

Regards

ASHFAQ

Re: maximum length of variable?

its_anandrjs — Sun, 02 Nov 2014 11:05:47 GMT

Hi,

I believe you can go for JOINS for this and provide consolidated output to the users by any report or in excel file, a report some thing ceated by the help of two or three files and use joins between them.

Regards

Anand

Re: maximum length of variable?

sundarakumar — Sun, 02 Nov 2014 11:29:35 GMT

Anand,

Thanks for the reply. Do u mean like, let user reload the application after placing an excel file with his required policy numbers. Or is it a user specific join in front end. Can u pls explain. ?

-Sundar

Re: maximum length of variable?

its_anandrjs — Sun, 02 Nov 2014 11:33:38 GMT

Yes, by placing the policy numbers list of excel file or may be provide it with any mapping table only those policy number to get the desire output and rest of the details.

Regards

Anand

Re: maximum length of variable?

Peter_Cammaert — Sun, 02 Nov 2014 14:01:38 GMT

Did a test (still running) and first conclusion is that variable content seems to be limited only by available RAM. At the moment, my variable contains a continuous string of about 100MB.

Two thoughts:

Available RAM as the only limit is pretty unpredicitable as the maximum content depends on the situation, and you'll never know when stuffing too much data in a variable will fail eventually...
Functions that you apply to a variable may become very slow because of the size of the data. Even QV internal operations may start to experience slowdowns.

I think there must be better ways to tackle a problem like this.

Peter

Re: maximum length of variable?

sundarakumar — Sun, 02 Nov 2014 17:07:16 GMT

Great Peter. Thanks for the effort

Can you pls tell me how much character this 100 mb variable has taken?

-Sundar.

Re: maximum length of variable?

sundarakumar — Sun, 02 Nov 2014 17:12:01 GMT

Hi Anand,

Nice suggestion. Thanks.

-Sundar

Re: maximum length of variable?

Anonymous — Mon, 13 Nov 2017 12:53:40 GMT

Hi Sundarkumar,

Did you get the solution for the same. I have the same scenario with 11 digit ID but my qliksense application has large data(qvf size is almost 4 GB) so considering this size can you please suggest the solution.

Thanks