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?
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
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.
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. ?
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.
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.
I think there must be better ways to tackle a problem like this.