Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
sundarakumar
Specialist II
Specialist II

maximum length of variable?

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

10 Replies
ashfaq_haseeb
Champion III
Champion III

A similar Solution attached.

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

Regards

ASHFAQ

sundarakumar
Specialist II
Specialist II
Author

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
Champion III
Champion III

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
Specialist II
Specialist II
Author

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
Partner - Champion III
Partner - Champion III

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
Specialist II
Specialist II
Author

Great Peter. Thanks for the effort

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

-Sundar.

sundarakumar
Specialist II
Specialist II
Author

Hi Anand,

Nice suggestion. Thanks.

-Sundar