maximum length of variable?

[sundarakumar]

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

[ashfaq_haseeb]

A similar Solution attached.

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

Regards

ASHFAQ

[sundarakumar]

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

[ashfaq_haseeb]

HI,

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

Regards

ASHFAQ

[its_anandrjs]

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

[sundarakumar]

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

[its_anandrjs]

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

[Peter_Cammaert]

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

[sundarakumar]

Great Peter. Thanks for the effort

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

-Sundar.

[sundarakumar]

Hi Anand,

Nice suggestion. Thanks.

-Sundar