topic Big Data Text problem: Can I create a QVD behind the scenes with match() result? in QlikView https://community.qlik.com/t5/QlikView/Big-Data-Text-problem-Can-I-create-a-QVD-behind-the-scenes-with/m-p/790912#M1028308 <HTML><HEAD></HEAD><BODY><P>I have 6+ million rows of text data (5+ GB) and I am matching the data with multiple key words. It is looks great in the dashboard. But switching key words in the dashboard causing performance issues due to size of the text. </P><P></P><P>The question is can I extract match results to QVD? By that my end users just use that QVD dashboard instead of maneuvering 6+ million rows every click? </P></BODY></HTML> Thu, 12 Feb 2015 05:11:53 GMT 2015-02-12T05:11:53Z Big Data Text problem: Can I create a QVD behind the scenes with match() result? https://community.qlik.com/t5/QlikView/Big-Data-Text-problem-Can-I-create-a-QVD-behind-the-scenes-with/m-p/790912#M1028308 <HTML><HEAD></HEAD><BODY><P>I have 6+ million rows of text data (5+ GB) and I am matching the data with multiple key words. It is looks great in the dashboard. But switching key words in the dashboard causing performance issues due to size of the text. </P><P></P><P>The question is can I extract match results to QVD? By that my end users just use that QVD dashboard instead of maneuvering 6+ million rows every click? </P></BODY></HTML> Thu, 12 Feb 2015 05:11:53 GMT https://community.qlik.com/t5/QlikView/Big-Data-Text-problem-Can-I-create-a-QVD-behind-the-scenes-with/m-p/790912#M1028308 2015-02-12T05:11:53Z Re: Big Data Text problem: Can I create a QVD behind the scenes with match() result? https://community.qlik.com/t5/QlikView/Big-Data-Text-problem-Can-I-create-a-QVD-behind-the-scenes-with/m-p/790913#M1028309 <HTML><HEAD></HEAD><BODY><P><SPAN>String comparison would be always (very) slow. Therefore it's better to use numeric-matches in this way that you creates multiple normal flag-fields which contain 0 or 1 and/or combined flag-fields which contain unique sums for certain matchings - maybe you could find here some hints: </SPAN><A href="https://community.qlik.com/t5/forums/searchpage/tab/message?q=multiple+flag">http://community.qlik.com/search.jspa?q=multiple+flag</A><SPAN>.</SPAN></P><P></P><P>Also could it be helpful if you could restrict the calculation with additional filters to certain areas or periods or similar - maybe per set analysis expression.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 12 Feb 2015 15:31:26 GMT https://community.qlik.com/t5/QlikView/Big-Data-Text-problem-Can-I-create-a-QVD-behind-the-scenes-with/m-p/790913#M1028309 marcus_sommer 2015-02-12T15:31:26Z