Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello devs,
I want to ask about the suitability of having very large fields in QlikView e.g, a RTF with 4000 characters. Specially when this fields are inside fact tables with millions of rows showed inside a pivot table. I have noticed that in this case the performance goes down.
Is there a document or guide that cover this? Or maybe a general document explaining that the issues with large datasets are not only with the number of rows but also with the number of fields and the size of them?
The best approach for this that I have thought is to do a document chaining when the rows available go down of a limit.
Any information on this topic will be appreciated.
Thanks.
Hello Christian
I have done an approach and it works .
This is like my script code:
DIRECT SELECT
ID,
RTF1,
RTF2
FROM
MAIN_TABLE
However there is more possibilities with IMPLICIT FIELDS.
Then I only show this fields in a detailed view. (just 2 select per time to the db).
Thanks for your help.
With hyperlink ist meant you could create in a link to any file you want - in your case were each single description saved in an own txt- or pdf-file and only if a user clicked the description will be opened.
- Marcus
Ok, I will check this approach with my bosses too.
Thanks.