I have created an inputfield so users can add there own coments which is then put into a straight table. I'm just wondering if I release a new version will the user lose their previous comments. If so, is there a way in which this can be prevented from happening?
One way you can do this is as soon as the user enters the comments you can store that using the micros into the excel sheet or text file and this way you can have those comments when you reload your qlikview application.
I take it you meant macro's in excel? The table is already quite memory expensive, do you think this would hinder it further in terms of calculation time?
You are only storing the comments in excel with the primary keys attached to it, in this way this works as other table for you and when u r retrieving you can very easily attach it with the main table.
I have done this in my last project and we used to have appx close to half a million rows in the main table (not in excel).
