I have a qlikview of trade data that is over 2 gigs with 22 million trades. When I refresh it, I can see all the data is loaded in fine, however when I then go to save the qwv, despite being 2 gigs big it only has 300,000 odd trades in it. It was previously only one gig, with the same number of trades but one less numeric field, and it would load and save fine.
I am aware of "Bug ID:22214 Internal 2 GB limit on symbol table size in file", and my version of qlikview is one prior to the fix, but I don't know how to tell how big symbol tables are. Any ideas where my data is going?