Any Way to Hard-Code Selections?

Mon, 03 Nov 2014 14:07:27 GMT

Can you somehow hard-code selections? For example, If I want to only see items related to orders that took place after 2010, is there any way to hard code this so that Qlik doesn't load anything before 2010?

Re: Any Way to Hard-Code Selections?

JonnyPoole — Mon, 03 Nov 2014 14:14:04 GMT

If its a universal filter than apply a WHERE filter in the data load in your script.

Go to file -> edit script and scroll or hit the tab where you are loading date related information

ex:

Load

Date,

otherfield1,

otherfield2,

etc..

from ....

Where Year(Date) >=2010;

topic Re: Any Way to Hard-Code Selections? in QlikView

Any Way to Hard-Code Selections?

Re: Any Way to Hard-Code Selections?