topic a burning question - pre defined data in QlikView https://community.qlik.com/t5/QlikView/a-burning-question-pre-defined-data/m-p/818945#M1030084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is one burning questions we have. From reading previous posts it also seems to be "one of the most common questions from a new QlikView developer".</P><P></P><P>Is it possible to <STRONG>pre-define</STRONG> your selection criteria in Qlikview like you do in most Report Writers and Query tools.</P><P></P><P>We use a system called Open Contractor that holds all our repairs data. It includes millions of transactions. We want to extract information for this system which we can do as we have created an ODBC connection. The problem&nbsp; is when we click reload it is bringing everything through and once it gets to aboiut 500,000 records freezes and crashes. The solution would be do build a pre-define in to say only load A, B and C.</P><P></P><P></P><P>Can anyone help?</P><P></P><P></P><P>Chris</P></BODY></HTML> Tue, 03 Feb 2015 17:57:19 GMT 2015-02-03T17:57:19Z a burning question - pre defined data https://community.qlik.com/t5/QlikView/a-burning-question-pre-defined-data/m-p/818945#M1030084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is one burning questions we have. From reading previous posts it also seems to be "one of the most common questions from a new QlikView developer".</P><P></P><P>Is it possible to <STRONG>pre-define</STRONG> your selection criteria in Qlikview like you do in most Report Writers and Query tools.</P><P></P><P>We use a system called Open Contractor that holds all our repairs data. It includes millions of transactions. We want to extract information for this system which we can do as we have created an ODBC connection. The problem&nbsp; is when we click reload it is bringing everything through and once it gets to aboiut 500,000 records freezes and crashes. The solution would be do build a pre-define in to say only load A, B and C.</P><P></P><P></P><P>Can anyone help?</P><P></P><P></P><P>Chris</P></BODY></HTML> Tue, 03 Feb 2015 17:57:19 GMT https://community.qlik.com/t5/QlikView/a-burning-question-pre-defined-data/m-p/818945#M1030084 2015-02-03T17:57:19Z Re: a burning question - pre defined data https://community.qlik.com/t5/QlikView/a-burning-question-pre-defined-data/m-p/818946#M1030085 <HTML><HEAD></HEAD><BODY><P>Please check your manual for "Incremental Load", so you slice your data and reloads only last day(or week, or month)</P></BODY></HTML> Tue, 03 Feb 2015 17:59:49 GMT https://community.qlik.com/t5/QlikView/a-burning-question-pre-defined-data/m-p/818946#M1030085 Clever_Anjos 2015-02-03T17:59:49Z