Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
A similar Solution attached.
What is the length of your policy number. Qlik Can handle quiet big amount of data.
Regards
ASHFAQ
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
HI,
I'm not really sure on how many values it stores may be Henric Cronström Can confirm this.
Regards
ASHFAQ
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
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
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
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:
I think there must be better ways to tackle a problem like this.
Peter
Great Peter. Thanks for the effort
Can you pls tell me how much character this 100 mb variable has taken?
-Sundar.
Hi Anand,
Nice suggestion. Thanks.
-Sundar