Filter of server data

[#1]

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?

[stabben23]

Hi,

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

[#3]

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

[stabben23 · Accepted solution]

Like this:

SQL SELECT *

FROM InvoiceTable

Where InvoiceType ='Paid'

;

[maxgro]

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.

OR

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