topic Re: Filter of server data in QlikView

Filter of server data

Wed, 18 Nov 2015 19:16:06 GMT

How do we filter data in Qlik? For example, I have a table on the server with all invoices, but I only want to see a certain types of invoices? Can this be done in Qlik or does there need to be a view already created on the server?

Re: Filter of server data

stabben23 — Wed, 18 Nov 2015 19:31:49 GMT

Hi,

The easiest way is to use where statment in your sql query or whatever you use.

Re: Filter of server data

Wed, 18 Nov 2015 19:36:33 GMT

Thanks Staffan. Where do I put this. With in the sheet? or before?

Re: Filter of server data

stabben23 — Wed, 18 Nov 2015 19:44:55 GMT

Like this:

SQL SELECT *

FROM InvoiceTable

Where InvoiceType ='Paid'

;

Re: Filter of server data

maxgro — Wed, 18 Nov 2015 19:48:01 GMT

You can filter data when you load (in the script editor) the data from an external source, file, database, etc,..... For a database you can start from Staffan's suggestion.

You can load all the data in Qlik and then filter in the user interface with QlikView objects.